Find Jobs
Hire Freelancers

Access spreadsheet content via database

€250-750 EUR

Selesai
Dibuat hampir 8 tahun yang lalu

€250-750 EUR

Dibayar ketika dikirim
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 Proyek: 10597123

Tentang proyek

12 proposal
Proyek remot
Aktif 8 tahun yang lalu

Ingin menghasilkan uang?

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda
Dapatkan bayaran atas pekerjaan Anda
Uraikan proposal Anda
Gratis mendaftar dan menawar pekerjaan
Diberikan kepada:
Avatar Pengguna
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 dalam 17 hari
4,5 (43 ulasan)
5,0
5,0
12 freelancer menawar dengan rata-rata €711 EUR untuk pekerjaan ini
Avatar Pengguna
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 dalam 10 hari
5,0 (167 ulasan)
9,3
9,3
Avatar Pengguna
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 dalam 21 hari
4,9 (81 ulasan)
6,3
6,3
Avatar Pengguna
Need more details
€750 EUR dalam 20 hari
0,0 (0 ulasan)
0,0
0,0

Tentang klien

Bendera SWITZERLAND
Zürich, Switzerland
5,0
5
Memverifikasi Metode pembayaran
Anggota sejak Mei 24, 2016

Verifikasi Klien

Terima kasih! Kami telah mengirim Anda email untuk mengklaim kredit gratis Anda.
Anda sesuatu yang salah saat mengirimkan Anda email. Silakan coba lagi.
Pengguna Terdaftar Total Pekerjaan Terpasang
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuat pratinjau
Izin diberikan untuk Geolokasi.
Sesi login Anda telah kedaluwarsa dan Anda sudah keluar. Silakan login kembali.