Export to Excel function Not working on Server machine

Question

I m having function which export data of datatable to an excel sheet.
it is working fine on local machine, or any other local machine,
but whn i upload ths code to server it not work ....

Plz help!!!!!!!!

Muralidharan Deenathayalan · Answer

Is it windows application / web application because in your export, i could see "using System . Windows . Forms ; the download folder is "c:\Navin\" folder as you mentioned in the config file.

navin thangaraj · Answer

i have modified my code to xml format.. da = new SqlDataAdapter (); conn . Open (); da . SelectCommand = command ; da . Fill ( ds ); ds . WriteXml ( "c:\Customers.xml" ); when i execute solution from the local system the data set values are copied to the xml file along with column header..then i moved the files to virtual directory under inetpub folder. through iis manager i browsed the virtual directory and run the same page , the file is getting saved in the same path but without the column header :(.. then i opened the same page from other machine through URL (thru inetrnal ip address) but the xml file is not saving to the machine.. plz help me out.. thanx n regards T.Navin

navin thangaraj · Answer

hi, its web application.. by mistake i have included it ... now i have removed it ...thnx aftr removing , i have restarted the server , still the same issue is there... i went to inetmgr, and then i , browse the virtual directory its working fine.. but when i access the same page through URL it's not working

navin thangaraj · Answer

hi, my local and server are the same machine...and i run the code from the local its working fine..and then i moved the aspx page to the virtual directory (inside inetpub ) and then i have try to access the same page through url the file is not getting downloaded.. how to check the read /write access to the download folder

Muralidharan Deenathayalan · Answer

Do you have read /write access to the download folder?

navin thangaraj · Answer

yeah i have office installed and the specified path ..

navin thangaraj · Answer

i am not getting any error message...the file is not getting downloaded in the specified folder... when i run from the local machine its getting saved in the folder..

Muralidharan Deenathayalan · Answer

Office is installed on the server and c:\Navin path exists in the server?

navin thangaraj · Answer

code behind file: using Excel = Microsoft . Office . Interop . Excel ; using System . Reflection ; using System . Drawing ; using System . ComponentModel ; using System . Windows . Forms ; string FilePath = ConfigurationManager . AppSettings [ "dataqueryfile" ] + "dataquery_" + DateTime . Now . ToString ( "yyyyMMddhhmm" ) ; Excel . Application oXL ; Excel . Workbook oWB ; Excel . Worksheet oSheet ; Excel . Range oRange ; // Start Excel and get Application object. oXL = new Excel . Application (); // Set some properties oXL . Visible = true ; oXL . DisplayAlerts = false ; // Get a new workbook. oWB = oXL . Workbooks . Add ( Missing . Value ); // Get the active sheet oSheet = ( Excel . Worksheet ) oWB . ActiveSheet ; oSheet . Name = "DataQuery" ; // Process the DataTable DataTable dt = ds . Tables [ 0 ]; int rowCount = 1 ; foreach ( DataRow dr in dt . Rows ) { rowCount += 1 ; for ( int i = 1 ; i dt . Columns . Count + 1 ; i ++) { // Add the header the first time through if ( rowCount == 2 ) { oSheet . Cells [ 1 , i ] = dt . Columns [ i - 1 ]. ColumnName ; } oSheet . Cells [ rowCount , i ] = dr [ i - 1 ]. ToString (); } } // Resize the columns oRange = oSheet . get_Range ( oSheet . Cells [ 1 , 1 ], oSheet . Cells [ rowCount , dt . Columns . Count ]); oRange . EntireColumn . AutoFit (); // Save the sheet and close oSheet = null ; oRange = null ; oWB . SaveAs ( FilePath + ".xls" , Excel . XlFileFormat . xlWorkbookNormal , Missing . Value , Missing . Value , Missing . Value , Missing . Value , Excel . XlSaveAsAccessMode . xlExclusive , Missing . Value , Missing . Value , Missing . Value , Missing . Value , Missing . Value ); oWB . Close ( Missing . Value , Missing . Value , Missing . Value ); oWB = null ; oXL . Quit (); // Clean up // NOTE: When in release mode, this does the trick GC . WaitForPendingFinalizers (); GC . Collect (); GC . WaitForPendingFinalizers (); GC . Collect (); web config file : add key = "dataqueryfile" value = " C :\ navin \ " /> add assembly = "Microsoft.Office.Interop.Excel, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71E9BCE111E9429C" /> add assembly = "office, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71E9BCE111E9429C" /> add assembly = "Microsoft.Vbe.Interop, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71E9BCE111E9429C" /> add assembly = "stdole, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" /> plz help me out.. thanx n regards T.Navin

Muralidharan Deenathayalan · Answer

What is the value in the FilePath variable? Can you please post the complete error message details?

navin thangaraj · Answer

even i am facing the same problm.. how to solve it .. in .cs file : ---------------- oWB.SaveAs(FilePath + ".xls", Excel.XlFileFormat.xlWorkbookNormal, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Excel.XlSaveAsAccessMode.xlExclusive, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);

Manikavelu Velayutham · Answer

Check the path where you save the file in server. or can you paste the code which will save the excel file.