VB.NET 2005: Open an Excel Spreadsheet, modify it and then save it

M

MaxGruven

I have the following requirement:

From a VB.NET Windows Form Application developed in VS.Net 2005, I need to
be able to customize an Excel Spreadsheet for a user of the program based
upon some choices made.

The Excel Spreadsheet has 3 headers rows (merged columns) across the top and
they never change. The 4th row is column headings for all the subsequent
rows which can be filled in with data.

The users may have Excel 2002, Excel 2003 or even Excel 2007 on their
machine. (I think this is the hard part. Our users can have one of 3
versions of Excel on their machines)

Is there a way, from VB.NET to open up our master Excel spreadsheet stored
on the user’s machine, remove columns that they don’t need and then write out
the modified spreadsheet to their My Documents folder?

TIA,
Max
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top