Avatar of chenyuhao88

asked on 

Generate Excel Spreadsheet On The Fly

Hey All,

I have a website which can generated CSV file on the fly. The thing is we want to let it generate excel file now. After I modified correspodning code, I found it did give me the xls file, but each line of data comes to the 1st grid of excel file.

So if I want each field of data goes to each cell of excel spreadsheet, is there any quick solution I can use?

P.S. I have used "Microsoft Excel 11.0 Object", but it looks like I need to re-generate the whole stuff. Thinking of I already have CSV content on hand, is it possible to convert to excel spreadsheet easily? (I am using dot net 1.1)

Thanks heaps all!

Response.AppendHeader("Content-type", "application/vnd.ms-excel")
            Response.AppendHeader("Content-Disposition", "attachment;filename=TEST.XLS")
            Response.AppendHeader("Pragma", "no-cache")
            Response.AppendHeader("Expires", "0")

Open in new window

.NET ProgrammingASP.NET

Avatar of undefined
Last Comment

8/22/2022 - Mon