Generate SQL insert statements from Excel / Csv file online
Lets say you get a Microsoft Excel file containing the following information: If you want to import these record in a SQL table, just save the excel file as CSV. Then upload it to
Tag: Excel
Convert column values to row values in Excel 2010
Use the past special operation: "Transpose" in Microsoft Excel 2010 to convert column values to row values: Select column values and press CTRL + C: Select a cell outside the range, in this example
Formatting a date to a specific string (like dd-MM-YYYY) in Microsoft Excel VBA
If you want to format a date to a specific date format, like dd-MM-YYYY in Microsoft Excel VBA, use: Dim specificFormatedString as String specificFormatedString = Format(Date,"DD-MM-YYYY")
Add a WebService reference to a Microsoft Office Excel sheet
> Start you’re webservice > Start Microsoft Office Excel > Show the Control Toolbox toolbar: > View > Toolbars > Control Toolbox > Enter Design mode by clicking the “Design Mode” button on the Control
Create Microsoft Excel documents with the Open Xml SDK with charts
See: http://blogs.msdn.com/brian_jones/archive/2008/11/04/document-assembly-solution-for-spreadsheetml.aspx You can now create Microsoft Office Excel documents which are compatible with the desktop client, with use of the Open Xml SDK. The created document can contain charts, formula’s etc. The data is
Microsoft Excel – VBA – Compile error: Can't find project or library SoapClient30
If you have a VBA macro in Microsoft Excel and a webreference to a webservice, you might get the famous Compile error: Can’t find project or library SoapClient30. In mine case it wasn’t missing the
Microsoft Excel – Calculate elapsed time from text “2008-02-11 09:45:12.023”
Select Kolom A en Format Cell as Text Enter the following values in colun A in Microsoft Excel A1 "2008-02-11 09:45:12.023" A2 "2008-02-11 10:20:12.323" Select Kolom B en Format Cell as TIME 37:30:55 Enter the
Shortcut for pasting unformatted text in Microsoft Excel
Alt+e+sWill open the paste special dialog en then you can choose “Text” (this will also work in other Microsoft Office applications like Microsoft Office Word) Or F2 and then CTRL+VWhen you are in a cell,
Remove ExpandedColunCount and ExpandedRowCount when using Microsoft Exel (*.xml) file as template
When you use a Microsoft Excel "*.xml" file as template for generating Microsoft Excel reports, remove the ss:ExpandedColumnCount="1" ss:ExpandedRowCount="1" x:FullColumns="1" x:FullRows="1" from the <Table> tag under the <Worksheet> tag. If you don’t remove these counters