Find Jobs
Hire Freelancers

Access spreadsheet content via database

€250-750 EUR

Completed
Posted almost 8 years ago

€250-750 EUR

Paid on delivery
I’d like to realize a software to provide spreadsheet content to a user via an internet database. Spreadsheet content should be stored as string (not as files) to search through all data easily, preferred as xml code, and most preferred as OfficeOpenXML code. Content: values, formats, cell format/styles, simple shapes. Database shall be MySQL and store besides spreadsheet content also storage time, user id, history (how content was modified) and so on. One shall be able to “read” to but also to write in the database. Reading and writing shall work “between” the users open spreadsheet (client side) and the database (server side). I wonder what’s the best way to create the reading/writing part! Following ideas/ways I see: A) Run a program – as spreadsheet add-in or as an operating system service (Windows service etc.) – on users PC to access the database (login information stored in ini-file); load data from database into this program, access user’s spreadsheet (for MS Excel via MS Interop) and write loaded data into user’s spreadsheet B) Establish a website with some tool installed like PHPExcel, access the database via this website (login information = login to website), with PHPExcel create a new spreadsheet model on website server, write loaded data into this model and get user to copy/paste from model into his spreadsheet (Are there other options?) From deployment point of view I’d go for option B) but I don’t like the idea to be dependent on PHPExcel. Or are there other php libraries to get this done? For both options I wonder if it is possible not to write into the spreadsheet but to create the spreadsheet file, access the xml code of the file and write/paste data from database directly into this code (which makes OfficeOpenXML code necessary). To get started focussing on Windows would be o.k.
Project ID: 10597123

About the project

12 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
my projects url is [login to view URL] In finance project i have used the excel sheet to database tabel conversion using php excel. same way i can do xml data to mysql datatabase conversion and then again excel sheet conversion for your project. Thank you.
€305 EUR in 17 days
4.5 (43 reviews)
5.0
5.0
12 freelancers are bidding on average €711 EUR for this job
User Avatar
Let's discuss more about project to finalize the proper scope with estimated cost and time so ping me over the freelancer chat. I am myself developer so you will directly work with me. No mediators. No managers. No subcontractors. Please check my my recent work for the technical expertise along with reviews & feedback on my profile page.
€721 EUR in 10 days
5.0 (167 reviews)
9.3
9.3
User Avatar
Hi. my name is Pablo. My possible solution: 1. Create a website, two user types can login , normal users and administrators. The administrator can create new Excel Files , display Excel modifications, show user working in these moment. The normal users only can change Excel Files 2. We can store an historial of modifications in OOXML into database. Only one user can edit a file in a specific moment. 3. All modifications could be made so online or going downloadin and uploading the files to and from the database 05/30/2016 NO PROBLEM WITH NEW SPEFICATIONS.
€611 EUR in 21 days
4.9 (81 reviews)
6.3
6.3
User Avatar
Need more details
€750 EUR in 20 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SWITZERLAND
Zürich, Switzerland
5.0
5
Payment method verified
Member since May 24, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.