Welcome To Snipplr


Everyone's Recent Snippets Tagged excel



Code is VBA...
0 8025 posted 14 years ago by dotNetkow
How to Export Data From SQL Server to Microsoft Excel Datasheet
0 2085 posted 14 years ago by derebus
0 995 posted 14 years ago by paschim
1 1243 posted 15 years ago by wizard04
Es muss eine Formatierung gespeichert werden (Format :: Formatvorlagen) Einzutragen in: Format :: Bedingte Formatierung
0 950 posted 15 years ago by tscheckenbach
0 1233 posted 15 years ago by fwso
0 1060 posted 15 years ago by lancemonotone
Find and replace substring in a cell.
0 1190 posted 15 years ago by lancemonotone
modified from branflake2267's post at oooforum.org: http://www.oooforum.org/forum/viewtopic.phtml?t=52942 usage: Paste into the Standard.Module1 macro file. Then, create xls2csv bash script containing: #!/bin/bash file="$(readlink -...
0 2609 posted 15 years ago by softmechanics
The easy way to set this up is to go to the macro window by pressing alt+F11. Select the sheet from left panel. there will be two drop down. from the left drop down select worksheet and from right drop down list select the event 'change'.
0 1253 posted 15 years ago by derekholmes
2 1124 posted 16 years ago by iTony
Face it! Whenever you make a website/app you always need to make XLS export for the simple people. I mean heaven to betsy if they have to take a csv file, or use phpMyAdmin. So Here are 3 little functions and a sample skeleton that I use fro...
6 1793 posted 16 years ago by brownrl
0 3149 posted 16 years ago by statsplank
This script will also work on any spreadsheet program like Google Docs.
0 1122 posted 16 years ago by pollusb
This example demonstrates interpolation using Excel's =TREND function by converting 70 degrees F to 21 Celcius. =TREND({0,100},{32,212},70) The {..} arrays can of course be replaced with a cell range specifier.
0 1310 posted 16 years ago by jimfred
Say you've got data combined in such a way that there is a repeated row header, but all the data is in different rows. If you were to consolidate all the rows down to one, only taking valid values (discarding blanks), you'd have one header row with a...
0 1046 posted 16 years ago by pckujawa
This is modified from code found here: http://www.meadinkent.co.uk/XLexport-text1.htm and here: http://www.meadinkent.co.uk/XLexport-text2.htm
0 1144 posted 16 years ago by BlueCockatoo
# Export MySQL Data as CSV This code takes a `mysql_query()` resource and outputs its rows into CSV spreadsheet format. Edit the `header('Content-Disposition...` declaration to tell the user's browser to either display the data as plain text or do...
6 1555 posted 16 years ago by mikegreen
0 1110 posted 16 years ago by goo
0 1259 posted 16 years ago by Wardy
0 921 posted 16 years ago by goo
This is saved from Gerhard Slettens weblog www.gersh.no. I just want yo keep it on snipplr so it easily can be fetched through textmate.
15 7007 posted 16 years ago by stavelin
Imports data from CSV (excel-compatible format) into MySQL. Also check the mysqlimport utility and the complementary SELECT ... INTO OUTFILE.
4 1577 posted 17 years ago by jarnaldich
1 1224 posted 17 years ago by mikegreen