I'm looking for a way to present excel documents on the web either by : converting Excel documents to html, css and javascript or by, using silverlight control I'm not looking for a way to program the conversion by my self. What I'm after is a control or library (open source or third - party ) which will enable me to present excel file...
I have a .NET DLL which is installed to the GAC, as it is used by several applications. One of these is an Excel workbook which references the DLL using .NET's COM interop facility. The COM tlb file is installed to an application directory. This all works fine except when an updated version of the DLL is installed. On some PCs the CO...
I've been asked a question by my manager and my initial thought was that it is not possible. Is there any way, using the scripting available to Excel 2007 to display a Google map inside a sheet? I've used Excel to house the data that I've then gone and generated a KML file to load into Google Earth, but now they want to see a pretty li...
Suppose I have a function attached to one of my Excel sheets: Public Function foo(bar As Integer) as integer foo = 42 End Function How can I get the results of foo returned to a cell on my sheet? I've tried "=foo(10)", but all it gives me is "#NAME?" I've also tried =[filename]!foo(10) and [sheetname]!foo(10) with no change. ...
Hi! I need a way to read a Excel file from a stream. It doesn't seem to work with the ADO.NET way of doing things. The scenario is that a user uploads a file through a FileUpload and i need to read some values from the file and import to a database. For several reasons i CAN'T save the file to disk, and there is no reason to do so eig...
We have an Excel spreadsheet with the Grand Totals at the top using a Forumla, but this isn't on the actual Pivot Table it's just in the spreadsheet. We have a client that wants the Grand Totals at the top of the Pivot Table and doesn't want us to use Formula. Does anyone know if this is possible (even using VBA or something, just so lo...
we are generating a excel report and we need to sort the data programmatically before saving the file. Is it possible to implement filter on a specific column i.e. sorting of a excel file programmatically using vb.net? As per your suggetion, in order to generate excel report with sorting on specific column I just implemented the logic ...
I have a subroutine that searches for an occurrence of a string in another workbook. I'm trying to get an error message to pop up if the string can't be found (it's most likely due to spelling mistakes), as vbModeless, and allows to user to click on the cell in the searched sheet with the correct value. Then I'd like to resume the search...
Certain directories are protected by Basic Auth using a .htaccess file on an older Apache 1.x server. Today a user pointed out that the username/password was requested twice for the file he had just posted - once when entering the directory to see the index, and then AGAIN when downloading the file. Finding this odd, I researched the usu...
I'm trying to read an Excel file (Office 2003). There is an Excel file that needs to be uploaded and its contents parsed. Via Google, I can only find answers to these related (and insufficient topics): generating Excel files, reading Excel XML files, reading Excel CSV files, or incomplete abandoned projects. I own Office 2003 so if I ne...
We want to use Microsoft.Office.Interop.Excel in our web application. Everything works fine on our local machines, but on our test machine we're running into problems. It has neither Visual Studio nor Office installed on it. We're using .NET framework 2.0 and the server is running on Windows Server 2003 with IIS6. Is there a dll that ...
Hi, My PHP script have to create a multi-tabs Excel file with a report in each tab, but those reports already exists as HTML pages, so I don't want to duplicate code and work. I know I can rename a HTML file to .xls, and Excel/OpenOffice Calc will open it as a spreadsheet, but I don't know how to have severals tabs. I do not even know...
I'm creating buttons dynamically on an Excel userform with the following code: With Me.CurrentFrame.Controls.Add("Forms.CommandButton.1") .Caption = "XYZ" .name = "AButton" .Font.Bold = True .ForeColor = &HFF& ... blah blah blah End With I'd like to assign a function to run when these buttons are clicked, but I can...
Please tell me a solution to suppress passsword prompting of an excel file. use Win32::OLE; my $xlApp = Win32::OLE->new('Excel.Application'); $xlApp->{Visible} = 0; $xlApp->{DisplayAlerts} = 0; # Open excel file. my $xlBook = $xlApp->Workbooks->Open("C:\\Documents and Settings\\username\\Desktop\\te...
I have created an ActiveX control using C++. I use Visual Basic code to instance the control in an Excel worksheet. I can only run the VB script once, subsequent runs cause the following runtime error when attempting to access the 'ActiveSheet' variable: Microsoft Visual Basic Run-time error '-2147319765 (8002802b)': Automation erro...
I have a huge (~950 variables) survey response spreadsheet, made 2-4x larger than it needs to be because each item's individual response options are reported in separate columns. E.g., If Question 2 is in cell A1 and has 3 response options, these are listed below the question in cells A2-C2, A3-C3, etc. Note: Only one of A2-C2, etc. is...
I have a ReportViewer control on my aspx page that renders a nice report with one of the columns being a percentage. I have put the format of the cell as p0 and it works fine. Users that export the report to excel notice that a decimal appears after the value. Ie. What used to be "20%" is now "20.%". How can I get rid of the "."? ...
I need the First Row in an Excel Spreadsheet to Print as the header on all pages. ...
I've been using an OleDb connection to read excel files successfully for quite a while now, but I've run across a problem. I've got someone who is trying to upload an Excel spreadsheet with nothing in the first column and when I try to read the file, it doesn't recognize that column. I'm currently using the following OleDb connection s...
I have a c# application that opens up a COM instance of excel and dumps some data from an Access 2000 database via oleDB onto the sheet then releases the excel object, but I get a window after I close the program with the title bar: DDE Server Error: [applicationName.exe] - Application Error I think I've narrowed this down to be an i...