excel

ADODB recordset in VBA says excel field is empty when it's not

I have an excel sheet I need to import in my Access database. The sheet looks like this: DATE RECEPTION DENOMINATION ITEM N° QUANTITE RECUE 06/01/2010 DVD-Sex ...

Excel listening to JMS Topics, is it possible?

Does anyone know whether there's an excel add-in for listening to JMS topics? ...

Opening Excel file from IE loses images embedded in footer, but not on all machines

I have an intranet application which allows the user to view a set of excel files created with Excel 2003. The user clicks a button, which runs window.open('http://server/path/file.xls', 'destwindow'). Running IE6 (corporate standard, sorry), my desktop pc is configured to open Excel documents in Excel (not in IE window). This all wor...

import data from excel in php

i want to import data from excel file using php. and then if possible to save it mysql database. Thanks ...

How to create a Appointment in a Shared Calendar (Sharepoint) with VBA (Macro)?

I am actually trying to make an appointment from an excel spreadsheet. I have all the information of the appointment, like subject, body, start and end dates, I actually can create an appointment but only with my personal calendar in outlook. How do I copy/move/create an appointment in a shared calendar in a sharepoint server? I've tri...

MS Excel: how to enter free-form text in cell with drop-down-list?

I'm having to do a little bit of user data validation in Excel which will be used for application upload. I have a list of values (LOVs) that I'm providing in a drop down box in an Excel. That's easy. Is there a way to also allow for free form text in the drop down list cell? Excel tries to validate it against the given LOVs. I don'...

Format an Excel column (or cell) as Text in C#?

I am losing the leading zeros when I copy values from a datatable to an Excel sheet. That's because probably Excel treats the values as a number instead of text. I created the worksheet in C# and I am copying the values like so: myWorksheet.Cells[i + 2, j] = dtCustomers.Rows[i][j - 1].ToString(); How do I format a whole column or each ...

Export Core Data information to Excel Sheet

I want to have an iPhone app where the user can export the data held by the application to an Excel spreadsheet (as well as a host of other formats). So the idea is that each entity would be a new row in the sheet, with the attributes being different columns. Is this possible? ...

Drop-down list in Excel cell

Hello gentlemen, I have a simple Excel speadsheet where in one column i write string values. What I need is to define some predefined values and instead of typing string select it from dropdown list. For instance for a column Store Name I want to select "Reebok", "Adidas" and so on. I understand that there can be several ways how to im...

Programmatically finding an Excel file's Excel version.

Hi All, I'm using an OleDbConnection to connect to a spreadsheet from a C# program. One of the parameters in the connection string is the Excel version. "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Book1.xls;Extended Properties="Excel 8.0;HDR=YES" Given the path of an Excel file how can I find out which Excel format version it us...

Write Excel data directly to OutputStream (limit memory consumption)

Hello, I’m looking for a – simple – solution to output big excel files. Input data comes from the database and I’d like to output the Excel file directly to disk to keep memory consumption as low as possible. I had a look to things like Apache POI or jxls but found no way to solve my problem. And as additional information I need to gene...

Saving Excel Add-In in Windows 7

I have an Excel add-in I am developing that works fine in Windows XP. However, I just got a hold of Windows 7 Professional and now I cannot save this add-in, either manually from the VBA Editor or programmatically using ThisWorkbook.Save. The error message says "Micrsosoft Office Excel cannot access the file 'C:\Program Files\Microsoft...

Problem opening Office 07 documents in SharePoint 07 library with read-only permissions

The call center managers for my company use document libraries in a SharePoint 2007 site to post training material and information to our phone reps. These reps are given read-only access to the libraries as to not change the documents posted by management, however we find that if management uploads an Office 07 document (either docx or...

Problem with toolbar in Excel 2003

Hi, I have a very simple Excel Addin build it in Visual Studio 2008 for Excel 2003, which creates a toolbar with some buttons. When I debug it, with System Format set to "English (United States)" it works great, without problems. However, this addin is going to be used with System Format set to "French (France)" too, and when I try to...

How to pin the header row in Excel in .NET?

I am creating an Excel spreadsheet in C#. I like to have the header (first) row pinned in place when the user scrolls the rows. How can I do this in C# (or VB.NET)? ...

Space Delimited 'Export To Text' Excel Macro Issue

I have the below vba macro to Export the selected cells into a text file. The problem seems to be the delimiter. I need everything to be in an exact position. I have each column's width set to the correct width(9 for 9 like SSN) and I have the cells font as Courier New(9pt) in an Excel Sheet. When I run this it comes out REALLY c...

Upload An Excel File in Classic ASP On Windows 2003 x64 Using Office 2010 Drivers

So, we are migrating an old web app from a 32-bit server to a newer 64-bit server. The app is basically a Classic ASP app. The pool is set to run in 64-bit and cannot be set to 32-bit due to other components. However, this breaks the old usage of Jet drivers and subsequent parsing of Excel files. After some research, I downloaded the 6...

Replace Strings with IDs in Excel

I have a Microsoft Excel worksheet that has hundreds of rows of items. The category column in this items worksheet is filled with category names, which are duplicated since it's a many-to-one relationship of items to categories. I would like to replace these category strings with IDs from a second worksheet that has a unique list of th...

are there any good unit testing packages for excel

are there any good frameworks that can help unit test code in excel ? ...

with vsto and excel more and more trying to incorporate visual studio and C#, is VBA dead ??

what is the future for excel vba? it seems like excel is on its third or fourth version of trying to get VSTO as the mainstream solution here. Is there a clear strategy? is vba going to die anytime soon? ...