Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
importing excel data
#3
Solved: 10 Years, 10 Months ago
Hi manishbhalshankar,

o.k, I am using the add sheet before the importsheet but still I received an error.
Line (1) sheetcount = DataTable.GetSheetCount
Line(2) If sheetcount < 2000 Then
Line (3) datatable.AddSheet(SheetName)
Line (4) datatable.ImportSheet Dir&ExcelName,SheetName,SheetName
Line (5) DataTable.SetCurrentRow(0)
End If


Thanks
Gali
Reply


Messages In This Thread
importing excel data - by galis - 11-29-2010, 07:45 PM
RE: importing excel data - by manishbhalshankar - 11-30-2010, 10:44 AM
RE: importing excel data - by galis - 11-30-2010, 07:05 PM
RE: importing excel data - by manishbhalshankar - 12-01-2010, 05:24 PM
RE: importing excel data - by galis - 12-05-2010, 05:39 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)