|
I need to import tabular data into my database. The data is supplied via spreadsheets (mostly Excel files) from multiple parties. The format of each of these files is similar but not the same and various transformations will be necessary to massage the...
Started by derfred on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
That....
Have your transformation code in a macro that gets called via Excel controls client's Excel files.
The simplest solution IMHO would be to use Excel itself - you'll get all the Excel built-in functions and macros for free.
|
|
Hi everyone,
Have a list of dates in excel in the format (this comes originally from csv):
23/11/09 07:27:02 23/11/09 08:01:50 23/11/09 08:38:58 23/11/09 09:40:01
What I want to do is count the number of these falling between hour blocks, like 7-8, 8-...
Started by baron on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Excel stores dates as number of days since 1900 or 1904 depending; 8,IF(HOUR(B1)<12,"YES","NO"),"NO")
You should use Excel functions, like HOUR(), to extract.
And will otherwise return false.
|
|
I can't resolve this issue, I found a similar question here but:
setting the workbook to Manual calculation (alt-m-x-m or alt-t-o>formulas) didn't work Setting editor options to disable: Auto syntax check & Background compile didn't work anybody have...
Started by Vincent on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
The problem effectively....
I have tried re-installing, I have tried the Excel options > Resources > diagnostic tool which reported that it fixed 1 issue but the problem remained.
Winword VBA IDE works fine, so it's only in Excel for the moment.
|
Ask your Facebook Friends
|
Hello all,
I have tried numerous ways to modify the responses to "Openening an Excel file from within project" to open an existing Excel workbook and also select and activate a minimized workbook but have totally struck out, Can anyone give me some guidance...
Answer Snippets (Read the full thread at microsoft):
XlMaximized....
XlWindowState.
WindowState = Excel .
Visible = True
XL.
Application
XL.
Application
'Set to new instance of excel
XL = New Excel .
Excel
Dim XL As Excel .
Interop.
Office.
Imports Excel = Microsoft .
|
|
I have about 200 Excel files that are in standard Excel 2003 format.
I need them all to be saved as Excel xml - basically the same as opening each file and choosing Save As... and then choosing Save as type: XML Spreadsheet
Would you know any simple way...
Started by kristof on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
The simplest way is to record macro for one file = "C:\temp\excel\" strFile....
You need to find the function of yourself doing it in Excel and then looking at the code).
But if you download the solution, it has code for Excel and PPT).
|
|
I'm creating a VB.net application with VS2005 which, at the moment, uses the DataGridView to emulate Excel style functionality on a very basic level. Before I go crazy with creating custom methods for the DataGridView to do some more advanced things, ...
Started by Neitherman on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
SpreadsheetGear....
You can ship excel viewer with your app
FarPoint has a Spread control that's Excel compatible or open source, Infragistics and Telerik make some of the best 3rd party tools that can perform excel like functionality.
|
|
In Visual Basic excel return the day of the week? cell A1 = Friday 2/10/12 8:00 PM
How do I test for the day of the week in the above type of date format
If cell A1 = Friday then etc. etc
Started by toms r on
, 1 posts
by 1 people.
Answer Snippets (Read the full thread at yahoo):
|
|
I'm currently using a library named http://www.codeplex.com/ExcelPackage>ExcelPackage to generate a large number of excel files.
Unfortunately it saves in an xlsx format, the Excel 2007 OOXML format. I need it in the earlier 2003 .xls format, for my...
Started by Wobin on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Can you get them to install this ?
Microsoft Office Compatibility Pack for Word, Excel have Excel 2007) is to do a "Save As..." and tell Excel to save it in the 2003 format), then you may want to consider creating a script that makes....
|
|
I have seen this http://blogs.msdn.com/pstubbs/archive/2004/12/31/344964.aspx .
However i want to get this working in C# Excel add-in using vsto 2005 SE, can any one help?
Started by Donald on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
You can) and macros to Excel through the....
Unfortunately, you can't define UDF in a managed VSTO Excel to load Excel I get: The customization assembly could not ne found or could not be loaded.
Assembly and make it visible from COM.
|
|
Gabhan Berry,Windows 7 Home Basic Product Key, a Program Manager on the Excel team,Office 2010 Professional, has just started up a new blog devoted to Excel programming. To Quote: his first blog post: Starting from today,Windows 7 Home Basic, I'll be ...
, 1 posts
Answer Snippets (Read the full thread at nhndd):
|
