EXCEL Tools Entire Workbook to CSV

From Tuflow
Revision as of 14:38, 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 Entire Workbook to CSV does exactly that, it exports the currently all sheets in the workbook and saves to individual csv files, using the worksheet name as the export filename.

In the image below, if the Entire Workbook to CSV is used, two new .csv files will be created:

  • "bc_dbase.csv"
  • "1002hr.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_Entire_Workbook_to_CSV&oldid=2369"