Click here to Skip to main content
12,629,804 members (27,772 online)
Rate this:
Please Sign up or sign in to vote.
See more: C# XML
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 30-Aug-12 9:29am
Updated 30-Aug-12 12:32pm
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)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.161205.3 | Last Updated 30 Aug 2012
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100