C#

[nawab]

Hi All,

Could anyone please help me out with the below requirement.

I need to write an application using c# which reads an excel sheet stored on the local disk. this excel sheet has 2 columns out of which the first column has the names of the files. Then Connect to VSS and check for those names in the VSS and get the date changed, version number and the name of the script in an excel sheet.

Thanks
Amaan

[Curtis Rutland]

I don't know what VSS is, but I can help you on reading the Excel doc.

There are two options. One is COM Interop; use the excel engine itself. Here's a good tutorial on creating excel docs, you should be able to figure out reading them from it.

The other way is to use it as a database. You can set up OleDb connections to excel spreadsheets. Check connectionstrings.com to find the proper connection string.

I think that the second way is the simpler way. If you need help with that, let us know.

[nawab]

Thanks brov,

VSS means Visual Source Safe.

Thanks again for the response

[george1106]

Hi! i've been using this article to solve some problems about reading excel files, it gets a dataset with all the worksheets the workbook has as datatables.

i hope it works, I can't remeber if it's allowed to put third party links, it's from codeproject. if it's not allowed, please tell me :D

this is the link

if it doesn't works, here it is
http://www.codeproject.com/KB/office...ataReader.aspx

i hope it helps you. it only has one problem, it only recognizes a limited number of columns in the excel file, but it can be solverd editing the source code. in your case, as there are only 2 columns, i think that's not going to be a problem.

[Curtis Rutland]

Code project should be fine, just don't post any spam links or links to competing forums.