IIS problem while using excel

Question

0.00/5 (No votes)

See more:

Hi,

in my application(ASP.NET,C#.NET), report comes in excel format. In one workbook, two sheets are there, in that one sheet is coping from another work book...
locally it is working fine, last day i have deployed my application in IIS, from there i have taken the report, in that workbook one sheet it is showing...which is originally created, another sheet(which is copied from another workbook) is not coming...not copied. Is there any problem with IIS configuration(I have done normal configuration). or in code? Please help me.

Thanks in advance...
Regards
murty

Posted 16-Jul-10 0:04am

dwadasi

Add a Solution

2 solutions

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)

Martin Jarvis · Answer 1 · 2010-07-16T08:16:00

Solution 1

This will be a code problem. What are you using to generate the Excel report?

Posted 16-Jul-10 8:16am

Martin Jarvis

dwadasi · Answer 2 · 2010-07-18T18:19:00

actually i have a parent file, in that one sheet is there with formats.
and another excel is required dynamically.(that is creating using XML)
Please see the below steps
Step 1: Creation of file in backup folder....

C#

string fileName="QA Report Day Ending " + DateTime.Now.Day.ToString() + "-" + DateTime.Now.Month.ToString() + "-" + DateTime.Now.Year.ToString() +  ".xls";
            string fName = Server.MapPath(@"Backup\") + fileName;
            string newFileName = fName;
            string oldFileName = Server.MapPath(@"Template\ParentFile.xls");
            File.Copy(oldFileName, newFileName, true);

Step 2: Creating XML format

XML

const string startExcelXML = "<xml version=\"\">\r\n<Workbook " +
          "xmlns=\"urn:schemas-microsoft-com:office:spreadsheet\"\r\n" +
          " xmlns:o=\"urn:schemas-microsoft-com:office:office\"\r\n " +
          "xmlns:x=\"urn:schemas-    microsoft-com:office:" +
          "excel\"\r\n xmlns:ss=\"urn:schemas-microsoft-com:" +
          "office:spreadsheet\">\r\n <Styles>\r\n " +
          "<Style ss:ID=\"Default\" ss:Name=\"Normal\">\r\n " +
          "<Alignment ss:Vertical=\"Bottom\"/>\r\n <Borders/>" +
          "\r\n <Font/>\r\n <Interior/>\r\n <NumberFormat/>" +
          "\r\n <Protection/>\r\n </Style>\r\n "

MIDL

const string endExcelXML = "</Workbook></xml >";
       myHtml.Append(startExcelXML);
       myHtml.Append("<ss:Worksheet ss:Name=\"Detail QA Report\">");
       myHtml.Append("<ss:Table>");
       myHtml.Append("<ss:Column ss:Width='100'/>");
       myHtml.Append("<ss:Column ss:Width='150'/>");
       myHtml.Append("<ss:Column ss:Width='100'/>");

XML

myHtml.Append("<ss:Cell ss:StyleID=\"s41\">" +
                                       "<ss:Data ss:Type=\"String\">");
                        myHtml.Append("This is the First Row");
                        myHtml.Append("</ss:Data></ss:Cell>");

myHtml.Append("</ss:Table>");
myHtml.Append("");
myHtml.Append(" </ss:Worksheet>");

Step 3: for copied work sheet

app = new Application();
app.Visible = false;
workbook = app.Workbooks.Open(newFileName, 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);
baseWorkBook = app.Workbooks.Open(originalFileName, 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);
Worksheet sheetSummary = new Worksheet();
baseWorkBook.Worksheets.Copy(workbook.Worksheets[1],Type.Missing);
baseWorkBook.Save();
Sheets xlSheets = workbook.Sheets as Sheets;
sheetSummary = (Worksheet)xlSheets[1];
sheetSummary.Cells[12, 2] = "QA Report Day Ending: "+ txtEndDate.Text.ToString();

MIDL

workbook.Save();
            workbook.Close(false, Type.Missing, Type.Missing);
            baseWorkBook.Save();
            baseWorkBook.Close(false, Type.Missing, Type.Missing);
            app.Quit();

This is what i have done,it is working on local system perfectly...I hope,in the IIS the workbook is not opening or not copying the worksheet...