locked
Convert excel 2007 to excel 2003 RRS feed

  • Question

  • User-30685017 posted

    According to my scenario, I want to convert Excel 2007 (.xlsx) file to Excel 2003 (.xls) from C sharp and asp.net. Help required!

    Friday, November 4, 2011 4:56 AM

All replies

  • User-248200860 posted

    Hi,

    you can try like this 

    string excel2007filename= Server.MapPath("file.xlsx");

    string excel2003filename=Server.MapPath("file1.xlsx");

    byte[] buffer=File.ReadAllBytes(excel2007filename)

    File.WriteAllBytes(buffer,excel2003filename);

    Friday, November 4, 2011 5:25 AM
  • User-30685017 posted

    hi reet

    Thanks for the reply, I tried this code but no change in xls file :(

    Any other idea ?

    Friday, November 4, 2011 5:45 AM
  • User1292382518 posted

    You need to work with Excel Com Component. The above code is just a kind of Copy-Paste code with the change in name. Probably this thread can assist you in that.

    http://forums.asp.net/t/1158465.aspx/1

    Friday, November 4, 2011 4:31 PM
  • User-1910946339 posted

    Why?  Excel 2003 can open Excel 2007 files.  The converter was released years ago in Windows update.

    Friday, November 4, 2011 7:26 PM
  • User-30685017 posted

    Thanks deepak, this thread seems like opening a excel file through code. But the problem is that my Hosting provider is supporting Microsoft ACE 12.0 driver (Excel 2007 support). I have to handle it with Jet driver (Excel 2003) thats why I want to convert Excel 2007 to Excel 2003 so that my application can handle both versions of Excel.

    Saturday, November 5, 2011 2:25 AM