excel-parser-processor

Automate downloads from Excel files in seconds. Simply does the tedious, repetitive operations for rows of Excel files and reports the results. It downloads files from URL(s) in column A, if a new filename is provided at column B it will rename before saving. It will even create sub folders if column C is filled with a valid folder name.

MIT License

Stars
216
Committers
8
excel-parser-processor - Fix for old xls files Latest Release

Published by btargac over 2 years ago

What's Changed

  • Fix processing .xls files that had the old mime type application/vnd.ms-excel - The Excel 5.0/95 Binary file formatted files. πŸ‘΄
  • Update development related dependencies such as babel friends. πŸ’»
  • Update electron version to 17 :electron:
  • Update electron builder version to 22 :electron:
excel-parser-processor - Support Extension free URLs

Published by btargac over 3 years ago

Support for URL(s) without an extension

Main changes
  • Support for saving files on your filesystem with extensions even if the url doesn't have an extension
    This means your URLs on excel file can be like http://digitale.bnc.roma.sbn.it/tecadigitale/img/giornale/TO00181645/1935/unico/00000006/original
  • Extension will be retrieved from mime-type / Content-type header from the http response
  • Avoid over writing the existing files if there are multiple urls with the exact same path
    Existing files will be reported as errors on the final report as well
And some developer debts are payed
  • Get rid of optional chaining plugin of babel, since its included in the core modules of babel
  • Update browserlist to reduce the number of polyfills added to the bundle
  • Reactivate codefactor for quick automatic code review support
  • And as always update some dependencies (webpack, babel, electron, jest etc.)
excel-parser-processor - Support Subfolders

Published by btargac almost 4 years ago

Support for subfolder creation

Now you can use the column C to create a subfolder and save the file into that folder

Main changes;

  • If there is a C column with a valid folder name, automatically creates that subfolder (if that doesn't exist ) and saves downloaded file in that subfolder.
  • multiple items can be stored in the same subfolder
excel-parser-processor - Support Multiple Steps

Published by btargac almost 5 years ago

Support for renaming downloaded item

now you can use the column B to rename the file before saving to your file system

  • rename feature added
  • ~10 βœ–οΈfaster processing items with batch downloads πŸš€
  • Content security Policy added to renderer
  • upgrade to electron 7 :electron: πŸŽ‰
  • event based communication is handled through preload script
  • disable node Integration
  • enable context isolation
  • upgrage to babel 7
  • upgrade to core-js 3
Badges
Extracted from project README
Dependency Status Build Status Github Tag codecov Backers on Open Collective Sponsors on Open Collective Open Source Helpers CodeFactor CodeQL
Related Projects