Hi Patrick,

Thank you for your reply.

To answer your question, yes, you should be able to use the above approach to fill and save your workbook to a file.

Please let me know if you have any further questions.

Thank you for your prompt rely. I looked at the information on creating excel spreadsheets but cannot find full examples I need.

How do I add/reference Infragistics Excel Engine in a ASP?

Can I use the following VBA code in ASP and fill the sheet by set the value of each cells?

' Create a workbook and set its format to Excel2007Template 
Dim newWorkBook As Infragistics.Documents.Excel.Workbook = New Workbook(WorkbookFormat.Excel2007Template)
' Add a worksheet to the workbook 
Dim worksheet1 As Infragistics.Documents.Excel.Worksheet = newWorkBook.Worksheets.Add("Sheet1")
' Set the value of one of the cells
worksheet2.Rows.Item(0).Cells.Item(0).Value = 14.56
' Save the workbook 
newWorkBook.Save("C:\ExcelBookTemplate.xltx")

Thanks,

Patrick

Hi Peter,

Due to project requirement, I am using ASP. I am also trying to find a way to export my igGrid to excel, pdf, etc. Any suggestions on how to get that done? I am searching online documents but cannot find any examples. Thanks

Patrick