Skip to content

Import from text archives (K-NET ASCII format) into excel pages

License

Notifications You must be signed in to change notification settings

halt9k/japan-earthquake-data-importer

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

47 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Japan earthquake data importer

This script:

  • unpacks in memory *.tar.gz archives with text tables (K-NET ASCII format)
  • parses them, converts formats and transforms rows/columns
  • places parsed tables into multiple auto-created Excel pages,
    based on pre-defined anchors from the template Excel file.

This allows not just simple import, but intended to be used with custom prepared Excel template, which already have calculation routines figured out. Excel will recalcuate eveything immidiately after import without additional manual steps.

Preview:

About

Import from text archives (K-NET ASCII format) into excel pages

Topics

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Languages