Why i am not getting the save option in my VB Code
why i am not getting the save option
jahmed3 said: Is there a better way of solving this problem or I have to create all the combinations. I could not find owb.Worksheets.Item(0).Columns("mycolumn").Width = 2000 so that I could have set "mycolumn" to some specified width. The columns collection only takes integer.
owb.Worksheets.Item(0).Columns("mycolumn").Width = 2000 so that I could have set "mycolumn" to some specified width. The columns collection only takes integer.
There are no named columns in excel, everything is indexed based - so you are going to have to work with column indexes rather than named keys.
There is an alternative - if you use the WebGridExcelExporter, you can handle the InitializeColumn event which will be fired for each WebGrid column. In that event, you can check for your conditions, and set the column width accordingly.
Hi Tony,
Thanks for the last post.
I have 35 checkboxes on my web page. Based on the selection of the checkboxes the columns are displayed on the ultrawebgrid. Now I want to export these columns to an excel sheet. I am setting the width of each column before creating the excel file. The user may select any number of checkboxes. The problem is that I have to make combinations of what the user selects. For example, there are 3 checkboxes on the page, the user may select only the first checkbox or the second checkbox or the third checkbox or the first and the secodn checkbox ....
If CheckBox1.Checked = True Then
owb.Worksheets.Item(0).Columns(0).Width = 2500
For i As Integer = 0 To UltraWebGrid1.Rows.Count
owb.Worksheets.Item(0).Rows(i).Cells(0).CellFormat.Alignment = HorizontalCellAlignment.Center
Next
End If
If CheckBox1.Checked = True AndAlso CheckBox2.Checked = True Then
owb.Worksheets.Item(0).Columns(1).Width = 6000
owb.Worksheets.Item(0).Rows(i).Cells(1).CellFormat.WrapText = ExcelDefaultableBoolean.True
owb.Worksheets.Item(0).Rows(i).Cells(1).CellFormat.Alignment = HorizontalCellAlignment.Center
Thanks,
Junaid.
The WebGridExcelExporter will automatically stream the file to the client. The Save method takes either a file name, or it can take a strem. You want to save to a stream. You can write to a memory stream, or write directly to the Response.OutputStream.