![]() ' Reapply renderers to source sheet view. = Nothingĭim columnHeaderRenderer As CellType.IRenderer = ![]() ' Temporarily remove renderers so serialization does not abort.ĭim rowHeaderRenderer As CellType.IRenderer = Private Function Clone(ByVal source As SheetView) As Spread.SheetView Spread.SheetView dolly = (Spread.SheetView)formatter.Deserialize(stream) ĭ = rowHeaderRenderer ĭ = columnHeaderRenderer Deserialize source sheet view into cloned sheet view and apply renderer. Reapply renderers to source sheet view. = null ĬellType.IRenderer columnHeaderRenderer = Temporarily remove renderers so serialization does not abort.ĬellType.IRenderer rowHeaderRenderer = Private Spread.SheetView Clone(SheetView source)īinaryFormatter formatter = new BinaryFormatter() See: Export Activate Sheet or given sheet to Excel, Link. You may want to just clone your sheet and then remove the hidden columns. Protected void lbwi_download_Click(object sender, LinkButtonWithImageEventArgs e)į spread = new () I also tried to save the new created excel first but it only generates an empty excel file. Ok so in my button event i create a new spread with one sheet and then iterate through the rows and columns of the spread in the website to copy the data.Īfter that i want to download the new created spread with the SaveExcelToResponse Command but i do not get a download window.
0 Comments
Leave a Reply. |