Enterprise Services Integration

Exporting to Excel using OpenOfficeXML 2.0 - Type 'SpreadsheetDocument' is not defined

markp11 — Tue, 24 Nov 2009 15:28:04 GMT

I have a requirement to be able to export data to an Excel spreadsheet (created on the fly) from an ASP.net application. I am attempting to use OpenOfficeXML 2.0 as this appears to be the way to go?

I have downloaded and installed the components from Microsofts site and set a reference in my Web Project to the DocumentFormat.OpenXML.dll, and as such in my classes I can see and reference all the objects associated with the DLL.

My application builds ok with no reported errors, however on running the application the browser opens and then shows the following:

Compiler Error Message: BC30002: Type 'SpreadsheetDocument' is not defined.

Line 34:     Public Sub NewSpreadsheet()
Line 35:
Line 36:         Dim sprdsheet As SpreadsheetDocument = SpreadsheetDocument.Create(FileName, SpreadsheetDocumentType.Workbook)
Line 37:         Dim WrkBookPart As WorkbookPart = sprdsheet.AddWorkbookPart
Line 38:         Dim wrkbook As New Workbook

At the start of my class I import the following:

Imports System.IO

Imports System.Linq
Imports DocumentFormat.OpenXml
Imports DocumentFormat.OpenXml.Packaging
Imports DocumentFormat.OpenXml.Spreadsheet

Public Class clsExcel

Public Sub NewSpreadsheet()
(see above)

I am not sure what I am doing wrong / missing and the usual searching of the web is turning up nothing. Could someone please help?

NB. I do not currently have Office 2007 installed on my PC so I am not sure if this is a pre-requisite for running OpenOfficeXML, my assumption is that it is not ?

Problem in sending mail after upgrade to exchange 2007

bhidwariav@iocl.co.in — Mon, 23 Nov 2009 11:23:42 GMT

I'm trying to send mail through Exchange 2007 but error comes saying "Untitled Page Syntax error, command unrecognized. The server response was: 5.7.3 Authentication unsuccessful. "

Please help.

The code is as follows:

Imports System.net.Mail
Imports System.IO
Partial Class _Default
 Inherits System.Web.UI.Page

 Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
 Dim Mail As New MailMessage(New MailAddress("from_email_id", ""), New MailAddress("to_email_id"))
 Mail.IsBodyHtml = True
 Mail.Subject = "Test Mail"
 Mail.Body = "Dear Sir, eMail Request is made for Creation List of Officers who have applied for email creation at BR Please do not reply to this email. "
 Dim smtp As New SmtpClient("IP_OF_SERVER")
 Dim credentials As New System.Net.NetworkCredential("USERNAME", "PASSWORD", "DOMAIN")
 smtp.UseDefaultCredentials = False
 smtp.Port = 587
 smtp.Credentials = credentials
 Try
 smtp.Send(Mail)
 Button1.Text = "OK"
 Catch ex As Exception
 Response.Write(ex.Message.ToString)
 End Try
 End Sub
 End Class

Export to Excel and Filename

saintperez — Mon, 23 Nov 2009 12:23:25 GMT

Hello, I am stuck on a problem with the out of data to Excel via

HttpContext.Current.Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "DummyTTDownload.xls"));

HttpContext.Current.Response.ContentType = "application/excel";

No matter what I do my output file contains "[1]" in the name in the form of myfile[1].xls when I click on the "Open" button. I have cleared temp folder and I still get the same thing. THe funny this is that if I click Save instead of Open the filename in the save dialog does not contain the "[1]". I cannot rely on the user to save the file on his/her computer with the name I want. Any advice is greatly appreciated:

I am using a third party tool for writing to the stream wich is helping me to export two DataTables to two sheets within the same workbook.

HttpContext.Current.Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "DummyTTDownload.xls"));

HttpContext.Current.Response.ContentType = "application/excel";

VM.xPort.Style oDateStyle = new VM.xPort.Style("DateFormat", "Tickets", 0, 0, oDS.Tables["Tickets"].Rows.Count - 1, oDS.Tables["Tickets"].Columns.Count - 1);

oD.Styles.Add(oDateStyle);

MemoryStream exportStream = (MemoryStream)oD.ExportToStream(oDS, xpOutputFormat.Excel8, true);

Response.OutputStream.Write(exportStream.ToArray(), 0, (int)exportStream.Length);

exportStream.Close();

exportStream = null;

Create a excel file and prompt user to save it

Usman Ghani — Fri, 05 Jan 2007 11:49:58 GMT

Hi There,

I am developing a website in vb.net, one part of it requires me to reade data from a db, save it in excel file and then prompt user to save this file. I have just no idea on how to create and write to an excelfile and prompt user to save it. Can someone here guide me pls how to achieve it and how to achieve all this, any special user permisisons required?

Regards,

Usman Ghani

how to make plug in for outlook

pradeepBaloni — Sat, 21 Nov 2009 06:55:58 GMT

hello....

hoe i make plug in for outlook.....

i don,t know how i start??????????????????

plz reply

Cannot create activex Component

omel81 — Tue, 17 Nov 2009 01:38:52 GMT

Hi All,

I've got some problem with my Mail Merge Function on Server. (Merge to mic. word). The problem is "cannot create activex Component". My Mail merge flow is Click 1 Hyperlink and go to word.application.

When i run that system in my PC...everything is ok...no error. In my PC using Mic. Office 2003.

When i deploy my system to server and run. I got error cannot create activex component. In Server using Mic. Office 2007. For ur information , everything in mic. office i install but still can't solved my problem. Help me please?.

extract csv

shaf555 — Sat, 21 Nov 2009 13:37:27 GMT

Can any one give me a sample
script to extract data from a specific location of a CSV file and export to
a specific cell in Excel file? pls........

Read and Write MS Excel file using c#.net

sachin_07 — Sat, 21 Nov 2009 05:39:07 GMT

Hello All,

I want to read multiple Microsoft Office e Excel files and want to consolidate those into one Excel file.

Please help me regarding the same.

Thanks in advance.

Regards,

Sachin

Get picture from Excel

1306 — Sat, 21 Nov 2009 09:47:36 GMT

Hi..all

i'am working with asp.net(C#) vs2005, and i have jobs to get picture in file Excel and save as that picture into drive D:

before,.. i'am sorry if my english is not good..

thank's all..

SAP.NET Connector and Visual Studio 2005

Neo77 — Wed, 05 Apr 2006 13:08:24 GMT

Not shure if I am in the right forum section ;-)

We are using the ASP.NET Connector 1.0 with Visual Studio 2003 and want to update to ASP.NET Connector 2.0.1 (which is designed for .NET 2.0 ???) and Visual Studio 2005.

But I've got no SAP stuff in VS 2005 to create a proxy or so...
Is there a way to integrate the SAP.NET Connector to VS 2005?

Anyone tried this or got a solution/hint?

Many thanks!

Chris

Word Automation using Microsoft office template in c#

oty.prem — Fri, 20 Nov 2009 09:57:53 GMT

Hi everybody..

I want to create a msword report using microsoft office predefined template in which i have to insert dynamic datas ,charts,images ,shapes .

Please suggest me how i can achieve this and send me some usefull links where i can get the tutorials

Thanks in advance....

Word Automation Export to word Problem

gsrs_shane — Thu, 19 Nov 2009 19:11:53 GMT

Hi ,
I am using word Automation to export to word .
I am getting a exception like
ex.message gives :- Command only available in print layout view.
ex.stacktrace gives :- at Word.View.set_SeekView(WdSeekView prop)
My code is I am trying to add a Image to Header ...
oWord.ActiveWindow.ActivePane.View.SeekView = WdSeekView.wdSeekCurrentPageHeader;
logoCustom = oWord.Selection.HeaderFooter.Shapes.AddPicture(logoPath,
logoCustom.Select(
logoCustom.Name =
logoCustom.Left = (
String logoPath = GetImgPath();ref oFalse, ref oTrue, ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing);ref oMissing);"CustomLogo";float)WdShapePosition.wdShapeLeft;
//SETTING FOCUES BACK TO DOCUMENT
oWord.ActiveWindow.ActivePane.View.SeekView =
WdSeekView.wdSeekMainDocument;
Can you please help me out...
I am using word 2003 and windows server 2003
Can you please help me out...

how to use plug in for outlook

pradeepBaloni — Thu, 19 Nov 2009 13:10:41 GMT

how to plug in for outlook with calender ????????????

plz reply...........

How to download emails from exchange server using C#.net

pathipati — Thu, 19 Nov 2009 07:09:47 GMT

How to download emails from exchange server using C#.net?

Error : System.Runtime.InteropServices.COMException: Command failed

openupped — Wed, 18 Nov 2009 03:06:03 GMT

Hi,

I make an asp.net project dealing with Microsoft.Office.Interop.Word.
It is working fine while running on VStudio 2005 Development Server.

But when I switch it to Win Server 2003, I get the following error :

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Runtime.InteropServices.COMException: Command failed

Source Error:
Line 24:         objWordApp.Visible = True 'IIf(chkShowWord.Checked, True, False)
Line 25:         'Open an existing document.
Line 26:         objWordApp.Documents.Open("C:\Sample.doc")
Line 27:         objDoc = objWordApp.ActiveDocument

Can somone please help ??!!!

Problem while connectiong the MailBOX using POP3 (Very Much Urgent Issue)

ravi_gupta_it@yahoo.com — Wed, 18 Nov 2009 09:30:04 GMT

Hi,

when i trying to connect the MailBox using POP3 it gives an error "A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 78.105.175.186:110"

Please suggect. it's very much urgent Issue

concatenating openxml documents with openxml sdk 2

TheChristian — Wed, 18 Nov 2009 08:30:51 GMT

Hello,

I've got this issue and i don't know how to sort it out.

I've tried with altchunk solution but it seeams that documents headers are missed and i cantl figure out how to fix it.

Thank you!

problems with images in header in open XML SDK

catsloveuse — Wed, 18 Nov 2009 08:18:54 GMT

Hello everybody,

I am working for three days on a simple picture to add in the header part.

When I add text in the hedare it works, when I add a picture in the document, it works, but when I want to insert the same picture in th eheader it generate error when I want to open the doument in Office Word 2007.

Does anybody got an idea ??

Here a peace of the code where there must be a mistake :

public Header MakeHeader()
    {
        Header header = new Header();
       // Paragraph paragraph = new Paragraph();
        
        //Text text = new Text();
        //text.Text = "blabla";


        ParagraphProperties paragraphProperties = new ParagraphProperties(
                        new ParagraphStyleId() { Val = "Header" },
                        new Tabs());

        Paragraph paragraph = new Paragraph(

                    paragraphProperties,
                    new Run(
                            new RunProperties(
                                new NoProof()),
                              new SimpleField(
                            new Drawing(
                                new wp.Inline(
                                    new wp.Extent() { Cx = 975250L, Cy = 731410L },
                                    new wp.EffectExtent() { LeftEdge = 19050L, TopEdge = 0L, RightEdge = 0L, BottomEdge = 0L },
                                    new wp.DocProperties() { Id = (UInt32Value)1U, Name = "myPicture", Description = "C:\\picture.png" },
                                    new wp.NonVisualGraphicFrameDrawingProperties(
                                        new a.GraphicFrameLocks() { NoChangeAspect = true }),
                                    new a.Graphic(
                                        new a.GraphicData(
                                            new pic.Picture(
                                                new pic.NonVisualPictureProperties(
                                                    new pic.NonVisualDrawingProperties() { Id = (UInt32Value)0U, Name = "C:\\picture.png" },
                                                    new pic.NonVisualPictureDrawingProperties()),
                                                new pic.BlipFill(
                                                    new a.Blip() { Embed = "rIdImagePart1", CompressionState = a.BlipCompressionValues.Print },
                                                    new a.Stretch(
                                                        new a.FillRectangle())),
                                                new pic.ShapeProperties(
                                                    new a.Transform2D(
                                                        new a.Offset() { X = 0L, Y = 0L },
                                                        new a.Extents() { Cx = 9753600L, Cy = 7315200L }),
                                                    new a.PresetGeometry(
                                                        new a.AdjustValueList()
                                                    ) { Preset = a.ShapeTypeValues.Rectangle }))
                                        ) { Uri = "http://schemas.openxmlformats.org/drawingml/2006/picture" })
                                )))));
        header.Append(paragraph);

        return header;
    }

        Footer footer = new Footer();

        ParagraphProperties paragraphProperties = new ParagraphProperties(
                        new ParagraphStyleId() { Val = "Footer" },
                        new Tabs(
                            new TabStop() { Val = TabStopValues.Clear, Position = 4320 },
                            new TabStop() { Val = TabStopValues.Clear, Position = 8640 },
                            new TabStop() { Val = TabStopValues.Center, Position = 4820 },
                            new TabStop() { Val = TabStopValues.Right, Position = 9639 }));

        Paragraph paragraph = new Paragraph(

                    paragraphProperties,
                    new Run(
                        new FieldChar() { FieldCharType = FieldCharValues.Begin }),
                    new Run(
                        new FieldCode(" TITLE   \\* MERGEFORMAT ") { Space = "preserve" }
                    ),
                    new Run(
                        new FieldChar() { FieldCharType = FieldCharValues.End }),

                    new Run(
                        new PositionalTab() { Alignment = AbsolutePositionTabAlignmentValues.Center, RelativeTo = AbsolutePositionTabPositioningBaseValues.Margin, Leader = AbsolutePositionTabLeaderCharValues.None }
                    ),
                    new Run(
                        new PositionalTab() { Alignment = AbsolutePositionTabAlignmentValues.Right, RelativeTo = AbsolutePositionTabPositioningBaseValues.Margin, Leader = AbsolutePositionTabLeaderCharValues.None }
                    ),
                    new Run(
                        new Text("Page ") { Space = "preserve" }
                    ),
                    new SimpleField(
                        new Run(
                            new RunProperties(
                                new NoProof()),
                            new Text("1")
                        )
                    ) { Instruction = " PAGE   \\* MERGEFORMAT " }
                );

        footer.Append(paragraph);

        return footer;
    }

    private static Document GenerateMainDocumentPart(structure Content)
    {
        var element =
            new Document(
                Content.Display(),
                new Body(
                    new Paragraph(
                        new Run(
                            new RunProperties(
                                new NoProof()),
                            new Drawing(
                                new wp.Inline(
                                    new wp.Extent() { Cx = 975250L, Cy = 731410L },
                                    new wp.EffectExtent() { LeftEdge = 19050L, TopEdge = 0L, RightEdge = 0L, BottomEdge = 0L },
                                    new wp.DocProperties() { Id = (UInt32Value)1U, Name = "myPicture", Description = "C:\\picture.png" },
                                    new wp.NonVisualGraphicFrameDrawingProperties(
                                        new a.GraphicFrameLocks() { NoChangeAspect = true }),
                                    new a.Graphic(
                                        new a.GraphicData(
                                            new pic.Picture(
                                                new pic.NonVisualPictureProperties(
                                                    new pic.NonVisualDrawingProperties() { Id = (UInt32Value)0U, Name = "C:\\picture.png" },
                                                    new pic.NonVisualPictureDrawingProperties()),
                                                new pic.BlipFill(
                                                    new a.Blip() { Embed = "rIdImagePart1", CompressionState = a.BlipCompressionValues.Print },
                                                    new a.Stretch(
                                                        new a.FillRectangle())),
                                                new pic.ShapeProperties(
                                                    new a.Transform2D(
                                                        new a.Offset() { X = 0L, Y = 0L },
                                                        new a.Extents() { Cx = 9753600L, Cy = 7315200L }),
                                                    new a.PresetGeometry(
                                                        new a.AdjustValueList()
                                                    ) { Preset = a.ShapeTypeValues.Rectangle }))
                                        ) { Uri = "http://schemas.openxmlformats.org/drawingml/2006/picture" })
                                ) { DistanceFromTop = (UInt32Value)0U, DistanceFromBottom = (UInt32Value)0U, DistanceFromLeft = (UInt32Value)0U, DistanceFromRight = (UInt32Value)0U }))
                    ) { RsidParagraphAddition = "00A2180E", RsidRunAdditionDefault = "00EC4DA7" },
                    new SectionProperties(
                        new HeaderReference()
                        {
                            Type = HeaderFooterValues.Default,
                            Id = "rId2"
                        },
                        new FooterReference()
                        {
                            Type = HeaderFooterValues.Default,
                            Id = "rId3"
                        },

                        new PageSize() { Width = (UInt64Value)11906U, Height = (UInt64Value)16838U },
                        new PageMargin() { Top = 1000, Right = (UInt64Value)1200U, Bottom = 1000, Left = (UInt64Value)1200U, Header = (UInt64Value)851U, Footer = (UInt64Value)992U, Gutter = (UInt64Value)0U }//,
            //new Columns() { Space = (UInt64Value)425U },
            //new DocGrid() { Type = DocGridValues.Lines, LinePitch = 312 }
                    ) { RsidR = "00A2180E", RsidSect = "00A2180E" }));
        return element;
    }

The footer works perfectly, the header whithout the picture works too, but this code doesn't work, please tell me why...

Thank you very much for your help.

Retrieving the COM class factory.... Error Message

Gregosc — Wed, 30 Aug 2006 15:31:16 GMT

Hi,

I try to create an appointment in the user calendar from aspx page with the following code :

Imports Microsoft.Office.Interop.Outlook

Dim objOutlook As New Application

Dim objOutlookAppt As MailItem

objOutlookAppt = objOutlook.CreateItem(OlItemType.olMailItem)

With objOutlookAppt

.Subject = "test"

.To = "gregory.schneider@kpmg.lu"

.Send()

End With

But I've always the same message :

Retrieving the COM class factory for component with CLSID {0006F03A-0000-0000-C000-000000000046} failed due to the following error: 80040154.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Runtime.InteropServices.COMException: Retrieving the COM class factory for component with CLSID {0006F03A-0000-0000-C000-000000000046} failed due to the following error: 80040154.

Thanks a lot

Grég

Opening Microsoft Word with ASP.NET (VB)

Nalum — Mon, 21 Apr 2008 11:24:43 GMT

Hey all,

I need to open a document with ASP.NET in MS Word but I don't really know how to go about it. I've read that I need to add Microsoft.Office.Interop name space, or a COM but other than that I don't have a clue what I have to do to do this.

Thanks for any help given

Excel 2007/ASP.NET Exception using .Workbooks.Add()

gsbell — Fri, 13 Apr 2007 19:28:06 GMT

Hi,

I am receiving the following exception when using the xlApp.Workbooks.Add() method with ASP.NET and Office 2007.

Server Error in '/ExcelTest' Application.

Microsoft Office Excel cannot open or save any more documents because there is not enough available memory or disk space.

• To make more memory available, close workbooks or programs you no longer need.

• To free disk space, delete files you no longer need from the disk you are saving to.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Runtime.InteropServices.COMException: Microsoft Office Excel cannot open or save any more documents because there is not enough available memory or disk space.

There is plenty of disk space and memory on the servers.

What's really strange is that it works OK when I specify a template with the Add method:
.Workbooks.Add(Server.MapPath("~") & "\ReportTemplate.xls")

So that's a workaround anyway...

Below is a small sample I'm using to try and debug this problem.

In a new web project, add a reference to Microsoft Excel 12.0 Object Library, add a button named btnGenerateReport, a label named lblStatus, and a Hyperlink named lnkExcelReport to Default.aspx and paste the following procedure into the code-behind file:

  Imports Excel = Microsoft.Office.Interop.Excel
Imports System.IO

Partial Class _Default
    Inherits System.Web.UI.Page

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

    End Sub

    Protected Sub btnGenerateReport_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnGenerateReport.Click
        Dim xlApp As Excel.Application = New Excel.Application

        xlApp.SheetsInNewWorkbook = 1
        xlApp.Application.DisplayAlerts = False
        xlApp.Application.AskToUpdateLinks = False
        xlApp.Visible = False

        ''''Dim xlBook As Excel.Workbook = xlApp.Workbooks.Add(Server.MapPath("~") & "\ReportTemplate.xls")	' WORKS OKAY
        Dim xlBook As Excel.Workbook = xlApp.Workbooks.Add()	' THROWS EXCEPTION
        Dim xlSheet As Excel.Worksheet = xlBook.Sheets(1)

        xlSheet.Range("A1").Value = "Hello World!"

        If xlSheet IsNot Nothing Then
            xlSheet = Nothing
        End If

        If xlBook IsNot Nothing Then
            xlBook.SaveAs(Server.MapPath("~") & "\Reports\Test.xls")
            xlBook.Close(False)

            xlBook = Nothing
        End If

        If xlApp IsNot Nothing Then
            xlApp.Quit()
            xlApp = Nothing
        End If

        lnkExcelReport.NavigateUrl = Request.ApplicationPath & "/Reports/Test.xls"
        lnkExcelReport.Text = "Test.xls"
    End Sub
End Class
Is anyone able to reproduce this or know of a solution?

Thanks,
Gordon Bell

Setting workbook options on excel services via asp.net

titiyoyo — Mon, 16 Nov 2009 17:55:09 GMT

Hello, I am trying to code a web interface in C# using Excel Calculation Services, to publish an excel workbook with only some of it's worksheets made visible. It would be just like setting the workbook's publishing options in Excel 2007. Problem is, i don't find any method or API to do this... Can somebody help me on this ?

Download excel sheet problem

hemal2801 — Fri, 10 Oct 2008 15:41:43 GMT

Hi Experts,

I just want to tell you that i had a problem at the time of import excel file.

Programme is in ASP.NET and C#.NET

I have one grid view which bind at design time and two combo box on the grid in Row temp let.

I have download excel file without this two combo box.

but column header has different name at design time like (01,02,03,......) and Column has different name in Table format in DB like (Col 1,Col 2,.......)

Excel sheet download with 01 column name.

I am using Ole Db connection object to Make connection and import excel data to SQL database.

but at the time of connection it gives below error.

when i want to import this file it gives error like (External table format is not valid)

Please help me out

ExportAsFixedFormat strange problem

ali_mostafa901 — Tue, 17 Nov 2009 09:36:04 GMT

Hello guys:

i'm developing an application to export Excel file to pdf format.

when running the application on my local machine , every thing is ok .

when hosting my application on the iis , i faced a strange problem .

Problem:

1-if the host machine's windows version is windows xp sp2 , every thing is ok.

2-if the host machine's windows version is windows xp sp3 or windows server 2003 sp2 , the application hangs and the conversion process failed .

i don't know the reason. please it is an urgent issue and i need urgent help

this is my code sample for conversion process:

Sub ConvertWorkbookToPDFXPS()' Declare variables to hold references to the Excel ApplicationClass

' and Workbook objects.

Dim excelApplication As ApplicationClass = Nothing

Dim excelWorkbook As Workbook = Nothing

Dim missing As Object = System.Reflection.Missing.Value' Declare a variable for the path to the workbook to convert.

Dim paramSourceBookPath As String = Server.MapPath("Reports.xlsx")' Declare variables for the Document.ExportAsFixedFormat method parameters.

Dim paramExportFilePath As String = Server.MapPath("MCS.pdf")Dim paramExportFormat As XlFixedFormatType = XlFixedFormatType.xlTypePDFDim paramExportQuality As XlFixedFormatQuality = XlFixedFormatQuality.xlQualityStandardDim paramOpenAfterPublish As Boolean = False

Dim paramIncludeDocProps As Boolean = True

Dim paramIgnorePrintAreas As Boolean = True

Dim paramFromPage As Object = Type.Missing

Dim paramToPage As Object = Type.Missing' Create an instance of Excel.

excelApplication = New Microsoft.Office.Interop.Excel.Application' Open the source workbook.

excelWorkbook = excelApplication.Workbooks.Open(Server.MapPath("Reports.xlsx"), Nothing, False)' Save it in the target format.

If Not excelWorkbook Is Nothing Then

excelWorkbook.ExportAsFixedFormat(Microsoft.Office.Interop.Excel.XlFixedFormatType.xlTypePDF, Server.MapPath("MCS.pdf"), Microsoft.Office.Interop.Excel.XlFixedFormatQuality.xlQualityStandard, missing, False, missing, missing, False, missing)

End If

' Close the Workbook object.

If Not excelWorkbook Is Nothing Then

excelWorkbook.Close(False)

excelWorkbook = Nothing

End If

' Close the ApplicationClass object.

If Not excelApplication Is Nothing Then

excelApplication.Quit()

excelApplication =

Nothing

End If

GC.Collect()

GC.WaitForPendingFinalizers()

GC.Collect()

GC.WaitForPendingFinalizers()

End Sub

thanks

Read the Selected value from Microsoft.Office.Interop.Excel.DropDown

srnilagiri — Thu, 04 Jun 2009 11:13:31 GMT

I am able to create a dropdown in Excel with the help of the code given here. I want to read the selected value from the dropdown. I tried this

Microsoft.Office.Interop.Excel.OLEObject obj;

obj = (Microsoft.Office.Interop.Excel.OLEObject)xlsWorksheet.DropDowns(1);

but getting exception.Please help.