Click here to Skip to main content
11,705,617 members (53,165 online)
Rate this: bad
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 8:29am
Edited 30-Aug-12 11:32am
Clifford Nelson at 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ő at 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
0 OriginalGriff 229
1 Sergey Alexandrovich Kryukov 100
2 Inimicos 60
3 ProgramFOX 50
4 Richard MacCutchan 45
0 OriginalGriff 9,053
1 Sergey Alexandrovich Kryukov 8,347
2 CPallini 5,189
3 Maciej Los 4,726
4 Mika Wendelius 3,626

Advertise | Privacy | Mobile
Web04 | 2.8.150819.1 | Last Updated 30 Aug 2012
Copyright © CodeProject, 1999-2015
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