locked
Batch excel file conversion in sharepoint 2007 document library RRS feed

  • Question

  • Hi,

    I have many excel files (.xls format) in several folders in numerous document libraries. I want these files to convert in batches in xlsx format.

    I don’t want to download files manually on my desktop and then convert each of them using online converter or any application.

    Can anyone help me if there is any method/online application so that we can pass the doc lib url and it automatically converts all the excel file and save them on my desktop. Sounds weird but still any suggestion on the similar lines will also helps.

    Thanks in advance.


    Sachin D Sharepoint Developer)
    • Changed type Mike Walsh FIN Thursday, June 2, 2011 12:25 PM q
    • Moved by Mike Walsh FIN Thursday, June 2, 2011 12:26 PM no workflow question in this post (From:SharePoint - Workflow (pre-SharePoint 2010))
    Thursday, June 2, 2011 6:21 AM

Answers

  • It will be easy enough to create a simple Console application in C#,

    Add reference to MS 2007 Excel Object

    Open the Document Library

    Loop through each document, open using Excel Object and Save as Xlsx files and check in the file..

    Regards

    Ranga

    • Marked as answer by Peng Lei Thursday, June 9, 2011 8:28 AM
    Tuesday, June 7, 2011 11:09 AM