Click here to Skip to main content
Rate this: bad
good
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
77Jeff533
Edited 30-Aug-12 11:32am
v2
Comments
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
Your Filters
Interested
Ignored
     
0 Shai Vashdi 1,518
1 Tadit Dash 350
2 Manas Bhardwaj 319
3 OriginalGriff 243
4 Sergey Alexandrovich Kryukov 240
0 Sergey Alexandrovich Kryukov 9,530
1 OriginalGriff 5,716
2 Peter Leow 4,320
3 Maciej Los 3,540
4 Abhinav S 3,373


Advertise | Privacy | Mobile
Web04 | 2.8.140415.2 | Last Updated 30 Aug 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Use
Layout: fixed | fluid