Thread: Create Excel Worksheet in C# / VB
View Single Post
  #2   Report Post  
Posted to microsoft.public.dotnet.languages.csharp,microsoft.public.excel.programming,microsoft.public.dotnet.framework.adonet
Miha Markic Miha Markic is offline
external usenet poster
  
Posts: 2
Default Create Excel Worksheet in C# / VB
Hi Horst,

Wild guessing he maybe iit s some sort of reserved word (i think it is
afraid of cell naming...).
Try with other names - they should work

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

"Horst Walter" wrote in message
m...
I create an Excel worksheet in C# (should be similar in VB)

Connection String:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filename + ";" +
"Extended Properties=Excel 8.0;";

Create string:
"CREATE TABLE S1 (Dt date, St char(40), Cr currency)"

Works fine, but the worksheet is named _S1 (UNDERSCORE!) and not S1.
Why does this happen? Any ideas?

Thx HW


Reply With QuoteReply With Quote