289,600 questions
0
votes
3
answers
1k
views
Excel column names
What column names cannot be used when creating an Excel spreadsheet with ADO.
I have a statement that creates a page in a spreadsheet:
CREATE TABLE [TableName] (Column string, Column2 string);
I ...
- 7,857
1
vote
4
answers
1k
views
How can I use classes from VisualBasic-Express in VBA for Excel or Access projects?
I saved my VB-Express code as .dll and registered it with regasm and made a .tlb file.
But when I try to run a function from it in an Excel-modul I get: Run-time error ‘453’: Can’t find DLL entry ...
- 930
0
votes
2
answers
9k
views
Array Formulas in Conditional Formatting of Excel XML Spreadsheet files?
Excel usually treats Conditional Formatting formulas as if they are array formulas, except when loading them from an Excel 2002/2003 XML Spreadsheet file.
This is only an issue with the Excel 2002/...
- 35.5k
3
votes
5
answers
176k
views
Is there a macro to conditionally copy rows to another worksheet?
Is there a macro or a way to conditionally copy rows from one worksheet to another in Excel 2003?
I'm pulling a list of data from SharePoint via a web query into a blank worksheet in Excel, and then ...
DerekF
3
votes
4
answers
4k
views
Elegant method for drawing hourly bar chart from time-interval data?
I have a list of timesheet entries that show a start and stop time. This is sitting in a MySQL database. I need to create bar charts based on this data with the 24 hours of the day along the bottom ...
- 117
3
votes
5
answers
3k
views
how can you parse an excel (.xls) file stored in a varbinary in MS SQL 2005?
problem
how to best parse/access/extract "excel file" data stored as binary data in an SQL 2005 field?
(so all the data can ultimately be stored in other fields of other tables.)
background
...
- 1,182
1
vote
2
answers
3k
views
How to iterate over all the page breaks in an Excel 2003 worksheet via COM
I've been trying to retrieve the locations of all the page breaks on a given Excel 2003 worksheet over COM. Here's an example of the kind of thing I'm trying to do:
Excel::HPageBreaksPtr ...
- 13
68
votes
14
answers
378k
views
How can I find last row that contains data in a specific column?
How can I find the last row that contains data in a specific column and on a specific sheet?
- 21.9k
4
votes
1
answer
2k
views
Setting Excel Number Format via xlcFormatNumber in an xll
I'm trying to set the number format of a cell but the call to xlcFormatNumber fails leaving the cell number format as "General". I can successfully set the value of the cell using xlSet.
XLOPER xRet;...
- 365
6
votes
3
answers
22k
views
How do you prevent printing dialog when using Excel PrintOut method
When I use the PrintOut method to print a Worksheet object to a printer, the "Printing" dialog (showing filename, destination printer, pages printed and a Cancel button) is displayed even though I ...
- 63
36
votes
4
answers
39k
views
Function Overloading and UDF in Excel VBA
I'm using Excel VBA to a write a UDF. I would like to overload my own UDF with a couple of different versions so that different arguments will call different functions.
As VBA doesn't seem to ...
- 626
3
votes
3
answers
7k
views
Is it possible to write ActiveX Controls in C# that will run in Excel?
I have been searching on the web for some example code on how we can write a custom ActiveX Control for use in Excel using .NET but so far I have found old articles suggesting that it is not supported....
- 1,537
3
votes
3
answers
6k
views
Excel like server side control for ASP.NET
We have a requirement to increase the functionality of a grid we are using to edit on our webapp, and our manager keeps citing Excel as the perfect example for a data grid :/ He still doesn't really ...
- 40.5k
3
votes
6
answers
5k
views
Top ten ordering in Excel based on complex team rules
I have an excel spreadsheet in a format similar to the following...
| NAME | CLUB | STATUS | SCORE |
| Fred | a | Gent | 145 |
| Bert | a | Gent | 150 |
| Harry | a | Gent | 195 ...
- 3,007
6
votes
2
answers
2k
views
Exposing .net methods as Excel functions?
I have a set of calculation methods sitting in a .Net DLL. I would like to make those methods available to Excel (2003+) users so they can use them in their spreadsheets.
For example, my .net method:...
- 22.8k
0
votes
5
answers
333
views
Options for PivotTables in Excel
I need to design a small project for generating excel reports in .NET, which will be sent to users to use.
The excel reports will contain PivotTables.
I don't have much experience with them, but I ...
- 82.3k
12
votes
13
answers
12k
views
Killing Excel.EXE on server [duplicate]
Possible Duplicate:
How to properly clean up Excel interop objects in C#
Suppose a ASP.NET web application generates automated Excel Reports on the server. How do we kill a server-side Excel.EXE ...
- 3,389
10
votes
5
answers
195k
views
Count a list of cells with the same background color
Each cell contains some text and a background color. So I have some cells that are blue and some that are red. What function do I use to count the number of red cells?
I have tried =COUNTIF(D3:D9,...
- 1,153
4
votes
3
answers
7k
views
Insert current date in Excel template at creation
I'm building an excel template (*.xlt) for a user here, and one of the things I want to do is have it insert the current date when a new document is created (ie, when they double-click the file in ...
- 418k
4
votes
5
answers
18k
views
What is the best way to package and distribute an Excel application
I've writen an Excel-based, database reporting tool. Currentely, all the VBA code is associated with a single XLS file. The user generates the report by clicking a button on the toolbar. Unfortunately,...
- 881
1
vote
9
answers
15k
views
How do I save a datagrid to excel in vb.net?
I know that this should be easy but how do I export/save a DataGridView to excel?
- 670
8
votes
8
answers
7k
views
How do you prevent leading zeros from being stripped when importing an excel doc using c#
I'm able to connect to and read an excel file no problem. But when importing data such as zipcodes that have leading zeros, how do you prevent excel from guessing the datatype and in the process ...
- 5,704
7
votes
5
answers
25k
views
How do I access Excel data source from an SSIS package deployed on a 64-bit server?
I have an SSIS package that exports data to a couple of Excel files for transfer to a third party. To get this to run as a scheduled job on a 64-bit server I understand that I need to set the step as ...
- 1,186
232
votes
32
answers
547k
views
Reading Excel files from C#
Is there a free or open source library to read Excel files (.xls) directly from a C# program?
It does not need to be too fancy, just to select a worksheet and read the data as strings. So far, I've ...
- 12.9k
82
votes
9
answers
172k
views
Refresh Excel VBA Function Results
How can I get a user-defined function to re-evaluate itself based on changed data in the spreadsheet?
I tried F9 and Shift+F9.
The only thing that seems to work is editing the cell with the function ...
- 28.8k