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
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