Hi,
A bit of update
Dim filepath As String = "C:\Documents and Settings\ABC\Desktop\test.xls"
Dim filetodelete As String = "C:\Documents and Settings\ABC\Desktop\test.xls"
oWorkbook.Save(filepath)
Response.AppendHeader("content-disposition", "attachment;filename=students.xls")
Response.ContentType = "application/ms-excel"
Response.WriteFile(filepath)
Response.End()
Using the above code I am able to send the excel file to the client machine but I dont want to save the excel file on the server(specific location) which is done using the save method.
Hi Tony,
1) I am working on a web application. When the excel is generated I am not prompted with an automatic save file dialog. I am providing the code below.
Protected Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button2.Click
UltraWebGridExcelExporter1.ExportMode = Infragistics.WebUI.UltraWebGrid.ExcelExport.ExportMode.Custom
Me.UltraWebGridExcelExporter1.Export(Me.UltraWebGrid1, oWorkbook.Worksheets("mySheet1"))
oWorkbook.Worksheets.Item(0).PrintOptions.CenterHorizontally = True
oWorkbook.Worksheets.Item(0).DefaultRowHeight = 0
oWorkbook.Worksheets.Item(0).Columns(0).Width = 4000
oWorkbook.Worksheets.Item(0).Rows(i).Cells(0).CellFormat.WrapText = ExcelDefaultableBoolean.True
oWorkbook.Worksheets.Item(0).Rows(i).Cells(0).CellFormat.Alignment = HorizontalCellAlignment.Center
Next
oWorkbook.Worksheets.Item(0).Columns(1).Width = 1200
oWorkbook.Worksheets.Item(0).Rows(i).Cells(1).CellFormat.Alignment = HorizontalCellAlignment.Center
oWorkbook.Save("C:\Documents and Settings\ABC\Desktop\test.xls")
End Sub
When the button is clicked the save dialog control does not come up automatically. Can you let me know what code I need to add.
2) And some of the controls like the ultrabutton, ultraprintdocument, ultraprintpreviewcontrol etc. are disabled. Can you let me know how to enable these controls.
Thanks,
Junaid.
Junaid,
If you're working in an ASP.NET application, there's no way for you to dictate where the file will get saved on the client-machine, they will automatically be prompted with a save file dialog. Are you working in an ASP.NET app or a Windows Forms app?
The save method of the workbook takes the location where the excel file is to be created.
oWorkbook.save("C:\Documents and settings\abc\desktop")
Instead of hardcoding the location I want the user to select the location of where the excel is to be created. I would appreciate if some replies to my post.
Junaid
There's currently no control over the printable area, but I'll pass on the request. Setting the column to hidden sounds like a good approach - glad you were able to find a solution, and thanks for sharing!
-Tony