A
Anjan
Hi,
I have developed an web application in asp.net,C#,Excel 2003 object
model, which converts a xml file into Excel file. In this application, I am
loading a input XML file into XMLDocument object and using XMLWriter i am
converting the input xml file into another xml file which can be directly
open in Excel 2003 application. After generating the new XML file format, I
am storing it on the harddisk. Immediately i am oppening the xml file in
Excel appliaction and saving it as ".xls" file on the hard disk again.
My Code Starts here
****************************************
Excel.Application exlApplication = null;
Excel.Workbooks exlWorkBooks = null;
Excel._Workbook exlWorkBook = null;
// Create the Excel application object
exlApplication = new Application();
exlWorkBooks = exlApplication.Workbooks;
exlWorkBook =
exlWorkBooks.Open("C:\XMLfile\new_xml_001.xml",Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing);
exlWorkBook.SaveAs("C:\XLSfile\new_xls_001.xls",XlFileFormat.xlWorkbookNormal,Type.Missing,Type.Missing,Type.Missing,Type.Missing,XlSaveAsAccessMode.xlExclusive,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing);
Ends Here
***************************
I have hosted this application on the Windows 2K Standerd Edition. It is
working on the another system with the same environment setup. But When we
install on the final environment it is hanging on the exlWorkBooks.Open
method. And it is giving Timed-Out error. When i check the Task Manager of
the machine it is giving launching DW20.EXE appliactions. I found it is a
office error reporting tool. But I am able to figure out what might be the
problem. I tried with "ReadOnly", "IgnoreReadOnlyRecomended" aurguments of
the exlWorkBooks.Open method. But it is not responding. It hangs on the open
methods of the Workbooks object.
If anybody could help in solving this problem I would be greate help for me.
Waiting for experts response/Solution.
Thanks in advance
Regards
Anjan
I have developed an web application in asp.net,C#,Excel 2003 object
model, which converts a xml file into Excel file. In this application, I am
loading a input XML file into XMLDocument object and using XMLWriter i am
converting the input xml file into another xml file which can be directly
open in Excel 2003 application. After generating the new XML file format, I
am storing it on the harddisk. Immediately i am oppening the xml file in
Excel appliaction and saving it as ".xls" file on the hard disk again.
My Code Starts here
****************************************
Excel.Application exlApplication = null;
Excel.Workbooks exlWorkBooks = null;
Excel._Workbook exlWorkBook = null;
// Create the Excel application object
exlApplication = new Application();
exlWorkBooks = exlApplication.Workbooks;
exlWorkBook =
exlWorkBooks.Open("C:\XMLfile\new_xml_001.xml",Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing);
exlWorkBook.SaveAs("C:\XLSfile\new_xls_001.xls",XlFileFormat.xlWorkbookNormal,Type.Missing,Type.Missing,Type.Missing,Type.Missing,XlSaveAsAccessMode.xlExclusive,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing);
Ends Here
***************************
I have hosted this application on the Windows 2K Standerd Edition. It is
working on the another system with the same environment setup. But When we
install on the final environment it is hanging on the exlWorkBooks.Open
method. And it is giving Timed-Out error. When i check the Task Manager of
the machine it is giving launching DW20.EXE appliactions. I found it is a
office error reporting tool. But I am able to figure out what might be the
problem. I tried with "ReadOnly", "IgnoreReadOnlyRecomended" aurguments of
the exlWorkBooks.Open method. But it is not responding. It hangs on the open
methods of the Workbooks object.
If anybody could help in solving this problem I would be greate help for me.
Waiting for experts response/Solution.
Thanks in advance
Regards
Anjan