Click here to Skip to main content
15,867,308 members
Please Sign up or sign in to vote.
4.00/5 (3 votes)
See more:
Is there any way to use an XML file as a cell map for copy/paste between 2 different excel sheets. I am using C# to write a program that would first copy specific cell values from one sheet and then paste the cell values to a different sheet. The cell values are all text. I would like to use an XML file to map the copy/paste function so that it can be edited without having to change/edit the actual code.

Please note I am teaching myself C#. I use VS2010 pro as my IDE. I have searched thoroughly for any examples with no success. If I am not phrasing the question correctly any corrections are appreciated.

Any system using this program would have Excel installed in some variation. Any suggestions or links to help would be greatly appreciated.
Posted
Updated 30-Aug-12 11:32am
v2
Comments
Clifford Nelson 30-Aug-12 15:22pm    
Sure, just have to write all the code to do it. Easy enought the read an excel spreadsheet. You can create an object to put the data into. You then can serialize the objects. Just reverse the process.
Zoltán Zörgő 30-Aug-12 16:01pm    
First of all: you can rely on an installed instance of Excel, or your code need to run without excel? In the later case are the files xls (2003 or below) or xlsx (2007,2010) or ods (OpenDocument)?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900