How to export excel(xls)file without warning message

Question

1.00/5 (2 votes)

See more:

Hi all,

Can any 1 please help me to export xls file without getting warning message,

I am able to upload xlsx file and able to convert it to xls but unable to open xls file without warning I am getting, file format is not supporting, can any 1 please give the soln...

error msg:

"The file you are trying to open, 'someFileName.xls, is in a different format than specified by the file extension. Verify that file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?"

Thanks a lot in advance,

Posted 2-Apr-13 1:04am

GaviGunda

Updated 2-Apr-13 2:47am

v4

Add a Solution

Comments

phil.o 2-Apr-13 7:14am

When you write : convert it to xls, do you make an actual conversion, or do you just change the extension ?

GaviGunda 2-Apr-13 8:50am

Hi phil.o,
thanks for replay,I need full conversion, in both cases ie by actual conversion or by changing extension I am getting same warning message, So which 1 would u prefer to get xls without warning/error message,n how to do that.. plz help

phil.o 2-Apr-13 8:56am

I don't prefer any, I was just driving your attention to the fact that changing a file's extension does not, in any way, change the format of the file.
As to the conversion, I have no clue on how to do it ; and I don't have time to google for you the way to achieve it. It's up to you to do this research.

The error message is pretty straightforward : you have a file with a given extension that does not correspond to the actual format of the file.

GaviGunda 2-Apr-13 8:58am

OK thanks.. I got this link regarding that error

http://blogs.msdn.com/b/vsofficedeveloper/archive/2008/03/11/excel-2007-extension-warning.aspx

but unable to resolve..

in this link they mentioned some key and value but where to Include not getting??

Maciej Los 2-Apr-13 8:59am

Code! We need to see your code!!!
Please use "Improve question" widget to update your question.

phil.o 2-Apr-13 9:04am

Thank you Maciej, I forgot this one :)

Maciej Los 2-Apr-13 10:41am

Phil, that comment was addressed to OP. ;)

GaviGunda 2-Apr-13 9:05am

I am able to get the fields present in xlsx into datatable from there I need to export to excel(xls)

here is my code

OleDbCommand cmd = new OleDbCommand("Select * from [" + RdsheetNames.SelectedValue.ToString() + "]", objConn);
OleDbDataAdapter oleda1 = new OleDbDataAdapter();
oleda1.SelectCommand = cmd;
DataSet ds = new DataSet();
oleda1.Fill(ds);
DataTable dtRecords = ds.Tables[0];

string XlsPath = Server.MapPath(@"~//test.xls");
string attachment = string.Empty;
if (XlsPath.IndexOf("\\") != -1)
{
string[] strFileName = XlsPath.Split(new char[] { '\\' });
attachment = "attachment; filename=" + strFileName[strFileName.Length - 1];
}
else
attachment = "attachment; filename=" + XlsPath;
try
{
Response.ClearContent();
Response.AddHeader("content-disposition", attachment);
Response.ContentType = "application/vnd.ms-excel";
string tab = string.Empty;

foreach (DataColumn datacol in dtRecords.Columns)
{
Response.Write(tab + datacol.ColumnName);
tab = "\t";
}
Response.Write("\n");

foreach (DataRow dr in dtRecords.Rows)
{
tab = "";
for (int j = 0; j < dtRecords.Columns.Count; j++)
{
Response.Write(tab + Convert.ToString(dr[j]));
tab = "\t";
}

Response.Write("\n");
}
Response.End();
}
catch (Exception ex)
{
//Response.Write(ex.Message);
}

Maciej Los 2-Apr-13 10:40am

I wrote Please use "Improve question" widget to update your question.. And what have you done?

2 solutions

Solution 1

http://stackoverflow.com/questions/10498375/how-do-i-save-an-excel-file-without-getting-a-format-warning-when-opening-using[^]

Refer this.

Posted 2-Apr-13 3:53am

IND-CODENAME-47

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

GaviGunda · Accepted Answer · 2013-04-07T21:11:00

Hi all,

Just Install O2003PIA and

after installing o2003PIA browse and add this dll as reference

Microsoft.Office.Interop.Excel.dll

add these namespaces

C#

using Microsoft.Office.Core;
using Excel = Microsoft.Office.Interop.Excel;
using System.Reflection;
using System.Diagnostics;

and code

C#

oleda1.Fill(ds);

 Microsoft.Office.Interop.Excel.Application oAppln;
                                    //declaring work book
                                    Microsoft.Office.Interop.Excel.Workbook oWorkBook;
                                    //declaring worksheet
                                    Microsoft.Office.Interop.Excel.Worksheet oWorkSheet;
                                    oAppln = new Microsoft.Office.Interop.Excel.Application();
                                    oWorkBook = (Microsoft.Office.Interop.Excel.Workbook)(oAppln.Workbooks.Add(true));
                                    //oWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)oWorkBook.ActiveSheet;
                                    int i2 = 0;
                                    foreach (DataTable table in ds.Tables)
                                    {
                                        //oWorkSheet = new Microsoft.Office.Interop.Excel.Worksheet();

                                        oWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)(oWorkBook.Worksheets.Add(Type.Missing, Type.Missing, Type.Missing, Type.Missing));
                                        if (i2 == 0)
                                        {
                                            oWorkSheet.Name = "first";
                                        }
                                        else
                                        {
                                            oWorkSheet.Name = "second";
                                        }
                                        oWorkSheet.Activate();
                                        //oWorkBook.Worksheets.Add(null, null, 1, null);
                                        //DataTable table = DATASETNAME.Tables[0];
                                        int ColumnIndex = 0;

                                        foreach (DataColumn col in table.Columns)
                                        {
                                            ColumnIndex++;

                                            oWorkSheet.Cells[1, ColumnIndex] = col.ColumnName;
                                        }
                                        int rowIndex = 0;
                                        foreach (DataRow row in table.Rows)
                                        {
                                            rowIndex++;
                                            ColumnIndex = 0;
                                            foreach (DataColumn col in table.Columns)
                                            {
                                                ColumnIndex++;
                                                oWorkSheet.Cells[rowIndex + 1, ColumnIndex] = row[col.ColumnName].ToString();
                                            }
                                        }


                                        // Worksheet worksheet = (Worksheet)oAppln.ActiveSheet;
                                        //worksheet.Activate();
                                        i2++;
                                    }

if u get ContextSwitchDeadlock warning message

Just click ctrl+alt+E in your project and select Managed Debugging assistance..

in that uncheck ContextSwitchDeadlock n OK

http://www.rocha.org/2010/05/contextswitchdeadlock-was-detected.html[^]

its working thanks for all your help.....