Browsing by Subject "Spreadsheet"

Now showing 1 - 1 of 1
  • Thumbnail Image
    Item
    Poster for "Excel Archival Tool: Automating the Spreadsheet Conversion Process"
    (2015) McGrory, John
    This poster presents the Excel Archival Tool, a script that was created to programmatically convert Microsoft Excel files into open source formats suitable for long-term archival. This is accomplished by using Visual Basic Script to convert Excel workbooks (.xls and .xlsx) into comma-separated value files (.csv), while also extracting charts/figures (in .png images), cell formulas (in .txt files), and formatting/styling information (in HTML snapshots). This tool is most useful for large Excel data sets that would otherwise require large amounts of tedious work to convert manually.