exporting to excel
-
Hi guys, i am building a program to export some data to excel, i've used this code: Set ExcelApp = CreateObject("Excel.Application") ExcelApp.Workbooks.Add Set ExcelBook = ExcelApp.ActiveWorkbook.Sheets(1) ExcelBook.Cells(1,1).Value = "name" ExcelBook.Cells(1,2).Value = "code" ExcelBook.SaveAs "E:\inetpub\wwwroot\dominios\file.xls" ExcelApp.Quit() Set ExcelApp = Nothing Set ExcelBook = Nothing but, im having problems with the "code" cell, i need to transform this cell into a string or text type, and i dont know how to do this, i already tried ExcelBook.Cells(1,2).Type = String, and didnt work... can some one help me please???? thank u very much... and sorry for the bad english.
-
Hi guys, i am building a program to export some data to excel, i've used this code: Set ExcelApp = CreateObject("Excel.Application") ExcelApp.Workbooks.Add Set ExcelBook = ExcelApp.ActiveWorkbook.Sheets(1) ExcelBook.Cells(1,1).Value = "name" ExcelBook.Cells(1,2).Value = "code" ExcelBook.SaveAs "E:\inetpub\wwwroot\dominios\file.xls" ExcelApp.Quit() Set ExcelApp = Nothing Set ExcelBook = Nothing but, im having problems with the "code" cell, i need to transform this cell into a string or text type, and i dont know how to do this, i already tried ExcelBook.Cells(1,2).Type = String, and didnt work... can some one help me please???? thank u very much... and sorry for the bad english.
-
it doesnt work for me, i need it in ASP, not in .NET... and it cant be on , cuz the outher program that will read the file, cant read this
(html) excel.... thank u anyway modified on Wednesday, February 10, 2010 10:49 AM -- Modified Wednesday, February 10, 2010 10:50 AM