EXCEL Tools Active Sheet to CSV

From Tuflow
Revision as of 14:35, 13 September 2011 by tuflow>Par
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

This tool is very useful for exporting the databases used by TUFLOW in csv (comma separated value) file. This can be used for boundary condition (bc_dbase), pit inlet databases and material databases. This allows you to work with Excel Worksheets, and export to csv for input to TUFLOW. The Active Sheet to CSV does exactly that, it exports the currently active worksheet and saves it as a csv file, using the worksheet name as the export filename.

In the image below, if the Active Sheet to CSV is used, the "bc_dbase" worksheet will be saved as a csv to a file called "bc_dbase.csv".

Excel Tools Export to csv.png
Up
Go-up.png Back to Excel Tips
Retrieved from "https://wiki.tuflow.com/w/index.php?title=EXCEL_Tools_Active_Sheet_to_CSV&oldid=2368"