Advertisement

06.12.2008 at 07:15AM PDT, ID: 23479524
[x]
Attachment Details

Create New XLS with C#

Asked by soapygus in Microsoft Visual C#.Net, Microsoft Excel Spreadsheet Software

Tags: C# .NET, 2.0

Hello Experts,

I have what I think is a pretty basic question -- I have modified the attached snippet to fill a spreadsheet from a dataview (via an array).  When the procedure completes the spreadsheet is visible and called "Book1."

I have been trying to modify the code so that I can create an xls with a specficied filename and then save and close the the XLS.

So how can I create an XLS called "c:\\mySpreadsheet.xls"?

Thanks for your help.

The attached snippet (pulled from http://support.microsoft.com/kb/302096/EN-US/)Start Free Trial
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
Excel.Application objApp;
      Excel._Workbook objBook;
 
      private void button1_Click(object sender, System.EventArgs e)
      {
         Excel.Workbooks objBooks;
         Excel.Sheets objSheets;
         Excel._Worksheet objSheet;
         Excel.Range range;
 
         try
         {
            // Instantiate Excel and start a new workbook.
            objApp = new Excel.Application();
            objBooks = objApp.Workbooks;
            objBook = objBooks.Add( Missing.Value );
            objSheets = objBook.Worksheets;
            objSheet = (Excel._Worksheet)objSheets.get_Item(1);
 
            //Get the range where the starting cell has the address
            //m_sStartingCell and its dimensions are m_iNumRows x m_iNumCols.
            range = objSheet.get_Range("A1", Missing.Value);
            range = range.get_Resize(5, 5);
 
            if (this.FillWithStrings.Checked == false)
            {
               //Create an array.
               double[,] saRet = new double[5, 5];
 
               //Fill the array.
               for (long iRow = 0; iRow < 5; iRow++)
               {
                  for (long iCol = 0; iCol < 5; iCol++)
                  {
                     //Put a counter in the cell.
                     saRet[iRow, iCol] = iRow * iCol;
                  }
               }
 
               //Set the range value to the array.
               range.set_Value(Missing.Value, saRet );
            }
 
            else
            {
               //Create an array.
               string[,] saRet = new string[5, 5];
 
               //Fill the array.
               for (long iRow = 0; iRow < 5; iRow++)
               {
                  for (long iCol = 0; iCol < 5; iCol++)
                  {
                     //Put the row and column address in the cell.
                     saRet[iRow, iCol] = iRow.ToString() + "|" + iCol.ToString();
                  }
               }
 
               //Set the range value to the array.
               range.set_Value(Missing.Value, saRet );
            }
 
            //Return control of Excel to the user.
            objApp.Visible = true;
            objApp.UserControl = true;
         }
         catch( Exception theException ) 
         {
            String errorMessage;
            errorMessage = "Error: ";
            errorMessage = String.Concat( errorMessage, theException.Message );
            errorMessage = String.Concat( errorMessage, " Line: " );
            errorMessage = String.Concat( errorMessage, theException.Source );
 
            MessageBox.Show( errorMessage, "Error" );
         }
      }
[+][-]06.12.2008 at 08:20AM PDT, ID: 21770466

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Microsoft Visual C#.Net, Microsoft Excel Spreadsheet Software
Tags: C# .NET, 2.0
Sign Up Now!
Solution Provided By: shekharsom
Participating Experts: 1
Solution Grade: A
 
 
[+][-]06.12.2008 at 08:51AM PDT, ID: 21770785

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628