Find Jobs
Hire Freelancers

Access spreadsheet content via database

€250-750 EUR

Terminado
Publicado hace casi 8 años

€250-750 EUR

Pagado a la entrega
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.
ID del proyecto: 10597123

Información sobre el proyecto

12 propuestas
Proyecto remoto
Activo hace 8 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 17 días
4,5 (43 comentarios)
5,0
5,0
12 freelancers están ofertando un promedio de €711 EUR por este trabajo
Avatar del usuario
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 en 10 días
5,0 (167 comentarios)
9,3
9,3
Avatar del usuario
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 en 21 días
4,9 (81 comentarios)
6,3
6,3
Avatar del usuario
Need more details
€750 EUR en 20 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de SWITZERLAND
Zürich, Switzerland
5,0
5
Forma de pago verificada
Miembro desde may 24, 2016

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.