How to create and update spreadsheet using OLEDB in C#?

Question

HI! all I am creating .xls spreadsheet file using following code

using (OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\temp.xls;Extended Properties='Excel 8.0;HDR=Yes'"))
{
    conn.Open();
    OleDbCommand cmd = new OleDbCommand("CREATE TABLE [NewSheet] ([Column1] string, [Column2] string)", conn);
    cmd.ExecuteNonQuery();
}

but i am getting an exception at cmd.ExecuteNonQuery();

Exception is: Cannot modify the design of table 'NewSheet'. It is in a read-only database.

Please help me to resolve this

Thank You

Community · Accepted Answer · 2017-05-23 11:48:23Z

2

You need to add readonly= false to your connection string, see:

Writing into excel file with OLEDB

edited May 23, 2017 at 11:48

CommunityBot

11 silver badge

answered Mar 15, 2010 at 12:18

Shiraz Bhaiji

65.7k37 gold badges149 silver badges260 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

vamshi Over a year ago

Thank you so much. I am getting following Exception at: conn.open(); Exception is: "Could not find installable ISAM." Please help

Joe Erickson · Accepted Answer · 2010-03-15 14:25:58Z

0

SpreadsheetGear for .NET will let you open, modify and save Excel workbooks, has no limits on the structure of a workbook, and does not rely on OLEDB or anything else (other than .NET 2.0+).

You can see live samples here and download the free trial here if you want to try it yourself.

Disclaimer: I own SpreadsheetGear LLC

answered Mar 15, 2010 at 14:25

Joe Erickson

7,2672 gold badges33 silver badges31 bronze badges

Collectives™ on Stack Overflow

How to create and update spreadsheet using OLEDB in C#?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related