Ranter
Join devRant
Do all the things like
++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatar
Sign Up
Pipeless API
From the creators of devRant, Pipeless lets you power real-time personalized recommendations and activity feeds using a simple API
Learn More
Comments
-
I am doing the simillar using PHPExcel library.
Its from DB to view to csv or xls or xlsx -
I literally have to do the same thing, I haven't started it yet tho. You using Dropboxs API?
-
Pwuts537y@Jilano :')
@Armohammadi That was autocorrect I hope? xD Thanks tho ;)
@heyheni I've attempted to introduce a decent PIM system in the past but my boss wants it to have all the checks and functions that the macros now fulfill..
@gojurimiba Yeah I've looked into PHPExcel and SimpleXLSX and I'm tending towards using the latter as I don't need the writing functionality. :)
@sha1 Wow, didn't expect that. :o
I'm using the API indeed, and since it only needs to be used with one account I enabled the direct token authentication thingy which means you don't have to go through the OAuth2 process to get a token. File download is working now :)
Related Rants
This week I got instructed to write a script that downloads an Excel sheet (which is used as a product database with >20000 products and lots of macros) from Dropbox, and parses it. In PHP. 🤦♂️
rant
hacky
excel
hacky shit
php
excel for data management
dropbox