Extend your .NET application with Excel

Thanks for this wonderful article

» Report offensive content

Microsoft Excel 11.0 Object Library
Office 2003 Update: Redistributable Primary Interop Assemblies

http://www.microsoft.com/downloads/details.aspx?FamilyID=3c9a983a-ac14-4125-8ba0-d36d67e0f4ad&DisplayLang=en

» Report offensive content

Hi
Can anyone help me?
i have web application (asp.net and C#) which needs to deal with Excel files
when i write following code in my application and execute application on client system it gives error as "access denied to file"

wb = excel.Workbooks.Open("c:\\test.xls", missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing);

whereas when i execute same code on server which is same as development system it works fine

can anyone tell me the solution???

Thnx
Shalaka

» Report offensive content

An excellent article. Find below code to save the document.....

NOTE: path_Name is the directory path.

string path_Name = null;

.....

path_Name = "C:\\Folder1\\File1_.xls";

.....

wb_New.SaveAs(path_Name,Microsoft.Office.Interop.Excel.XlFileFormat.xlXMLSpreadsheet, missing, missing, missing, missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, missing, missing, missing, missing, missing);

» Report offensive content

hi, I would like to know how to pick up values from an excel cell which has errors. Say when u convert a number in a cell to text then a green triangle appears at the top left corner. From such a cell when I try to pick values using a data reader/ dataset, it returns null. I have also tried running a macro and disabling the background error checking and number to text error checking to false as in:

oBooks.Application.ErrorCheckingOptions.BackgroundChecking = false;
oBooks.Application.ErrorCheckingOptions.NumberAsText = false;

But it has proved to be of no use. Please help!

» Report offensive content

Hi there,

we are in trouble saving an Excel file we have just created programmatically. The trick is in using different versions of Excel spreading from 2000 to 2003. With xp/2k3 we reach our goal using Worksheet.Save(...), which doesn't work with 2000.
We have experimented success with 2000 using Application.SaveWorkspace(...), which works on XP and doesn't fail in 2k3.
However, in Excel 2k3 you will see the SaveAs Dialog box appear to the user, even if you have prevented alerts to be showed.

We are using Microsoft.Interop.Excel, and there is one more strange thing: the Application.DisplayAlerts property works in all version, if compiled from a machin with same version.
If you compile that code on a Office XP machine and execute it on a Office 2k3, it will result in an odd message "Old version...".
Compiling code on a Office 2k3 machine, however, will run succesfull the same code. This seams to lead to an Interop issue, based on differents CLASSID mapped to the same property.

So the relevant question: is possible to save an Excel file programmaticali regardless of the Excel version? It is unrelevant if the file has a format without backword compatibility (which is not, however, 'cause you can open a 2k3 file with Office 2K), we need just to persist the file.

Second, if the first question is answered "no", is there a way to "detect" the Excel version running (without serach the registry) and make some switch "web-like"?

Thank you for all kind of suggestion.

» Report offensive content

Shalaka,

"Access denied" is not for file, but for RPC (Remote Procedure call) in Excel application (DCOM), you have to go to "Control Painel/Administrator Tools/Component services" look for DCOM, look for Excel (Name depends on Excel version, and the name should be thinks like "file of microsoft excel") , select properties and change security access for IIS user, do not put all access for user "every one"!!! Server security is very important...

Gustavo S. Borges

» Report offensive content

contents of datatable into excel spreadsheet in asp.net

need to look at a program that can put a datatable into an excel spreadsheet in asp.net 2.0 vb.net



Customer      Shopper ID      Year      Period No      Period Name      Prestige Gross Sales      Prestige Net Sales      Prestige Discount      Nb. Prestige Transactions

256039201      1      2005      12      Jan      64      50.15      -5.6      3



this is a datatable using the viewer built in.



Using Excel = Microsoft.Office.Interop.Excel;

public class ExcelPush

{

        Excel.ApplicationClass _excel = new Excel.ApplicationClass();



        public ExcelPush()

        {

            //

            // TODO: Add constructor logic here

            //

        }



        public Excel.Worksheet Activate()

        {

            // open new excel spreadsheet

            try

            {

                Excel.Workbook workbook = _excel.Workbooks.Add(Type.Missing);

                _excel.Visible = true;

                Excel.Worksheet ws = (Excel.Worksheet)_excel.ActiveSheet;

                ws.Activate();

                return ws;

            }

            catch (Exception ex)

            {

                Console.WriteLine(ex.ToString());

            }



            return null;

        }





        public void AddItemToSpreadsheet(int row, int column, Excel.Worksheet ws, string item)

        {

            ((Excel.Range)ws.Cells[row, column]).Value2 = item;

        }

}



   





End Class



Private Sub cmdProceed_Click(ByVal sender As Object, ByVal e As System.Web.UI.ImageClickEventArgs) Handles cmdProceed.Click

        Dim dt As New DataTable

        dt = _calendar.GetBusinessCalendarPeriod(txtPeriod.Text)

        Dim selectedConnectionString As String = String.Empty

        Dim selectedDBName As String = String.Empty

        Dim selectedServerName As String = String.Empty

        ' Get the correct connection string and database name

        If Not ddlDivisions.SelectedItem Is Nothing Then

            For Each div As Division In _divisions

                If div.Name = ddlDivisions.SelectedItem.Text Then

                    selectedDBName = div.DatabaseName

                    Exit For

                End If

            Next

        End If



        Dim rowNumber As Integer

        Dim NewDataTable As DataTable

        rowNumber = 0

        For Each rw As DataRow In dt.Rows

            NewDataTable = _customer.GetCustomerList(selectedDBName, rw)

          ****************************** Call excell routine.

        Next



    End Sub



 Dim rowNumber As Integer

        Dim NewDataTable As DataTable

        rowNumber = 0

        For Each rw As DataRow In dt.Rows

            NewDataTable = _customer.GetCustomerList(selectedDBName, rw)

          ****************************** Call excell routine.

        Next

» Report offensive content

i added the com component Microsoft.Excel 11.0 Object Library, but it showing error of name space Microsoft.Office.Interop.Excel,
what is the name space for Microsoft.Excel 11.0 Object Library, iam using framework 1.1

» Report offensive content

Hello,
Can any one tell me when i run excel application using asp.net in IE it is working well but when i open in firefox mozilla it is giving an error that it is not at all taking the correct path of excel sheet , it is saying that have chaged the path of excel sheet .

» Report offensive content

Hi..
i am working on one asp.net(c#) application where i want to upload an excel file to sql server.How do i do it??? i have added a reference of Microsoft Office 11.0 object Library.....now what next to do??

» Report offensive content

hi
i am trying to open other excel formats in office 2007 using a code similar to above, i have changed the interop assemblies of version 12 but am still getting an error of old format? can yu please help? 0x80028018;

» Report offensive content

Works like a dream. Thanks very much for that.

» Report offensive content

help me to solve error about use vb.net makes excel file

Private Sub cmdExportToExcel_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdExportToExcel.Click

        Dim ExcelApp As New Excel.Application

        Dim ExcelBooks As Excel.Workbook

        Dim ExcelSheets As Excel.Worksheet



        ExcelApp.Visible = True

        ExcelBooks = ExcelApp.Workbooks.Add ' ERRER HERE

        ExcelSheets = CType(ExcelBooks.Worksheets(1), Excel.Worksheet)

» Report offensive content

Hi, thanks Tony Patton, awesome article - it works!.
Ideally for my application I want to create a program with vb 2008 express and have it as an addin in excel 2007. Can it be done with these name spaces dicussed here or does one need vb 2008 professional?

» Report offensive content