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 -...

excel

0 631 posted 11 years ago by softmechanics

Visual Basic Remove Hyperlinks from Excel document

excel

0 271 posted 11 years ago by a1ias

Visual Basic Excel: Run Macro on Cell Change

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'.

excel

0 377 posted 12 years ago by derekholmes

Visual Basic Find duplicate cells in excel column

excel

0 335 posted 12 years ago by a1ias

PHP Export to MS Excel for MySQL Database

excel

2 345 posted 12 years ago by SteveMcDaniel

PHP Downloadable Excel File with PHP

excel

2 342 posted 12 years ago by iTony

PHP PHP Export MySql Table to Xls

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...

excel

6 603 posted 12 years ago by brownrl

SAS Import from and Export to Excel

excel

0 417 posted 12 years ago by statsplank

Other Excel function to extract a filename from a fullpath

This script will also work on any spreadsheet program like Google Docs.

excel

0 331 posted 12 years ago by pollusb

Other Interpolation in Excel using =TREND (interpolate)

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.

excel

0 426 posted 12 years ago by jimfred

Visual Basic Look up all occurences and merge results (consolidate)

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...

excel

0 293 posted 12 years ago by pckujawa

VB.NET Exporting Excel cells as individual text files

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

excel

0 385 posted 12 years ago by BlueCockatoo

PHP Export MySQL Data as CSV

# 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...