English 中文(简体)
Platform or tools for merging & filtering spreadsheet data online?
原标题:

My clients produce lots of data in the form of ad hoc spreadsheets, which they want to upload to their web site and then be able to create online, reports that require joins and filtering of the results. These report should not require any custom coding but will be made with the help of the online platform - the users will be able to choose which spreadsheets to join and which results they get.

Is there a platform or a tool that can do something like that?

If these spreadsheets had a predefined structure, then it would be possible to write some server side code that would parse them and give some online options for filtering, but if the spreadsheets are ad hoc it is much more complicated.

One thing that might be possible would be to import the spreadsheets in phpmysqladmin and operate on them as db tables, but the UI is very complicated for my audience.

最佳回答

You can have a look at Excel Services but I m sure that, and probably all other solutions out there, will require a fixed structure in you Excel sheets.

Like "the users will be able to choose which spreadsheets to join and which results they get" is a bit too fuzzy as a business requirement :) I guess the only tool that would be good at that is Excel itself.

问题回答

Can they achieve what they want using an on-line spreadsheet provider, like Google Docs?

If spreadsheet logic can be used to create the final reports, and collaboration is the purpose of putting them online, then perhaps something like this may be suitable?

You should try the Open XML SDK 2





相关问题
import of excel in SQL imports NULL lines

I have a stored procedure that imports differently formatted workbooks into a database table, does work on them then drops the table. Here is the populating query. SELECT IDENTITY(INT,1,1) AS ID ...

Connecting to Oracle 10g with ODBC from Excel VBA

The following code works. the connection opens fine but recordset.recordCount always returns -1 when there is data in the table. ANd If I try to call any methods/properties on recordset it crashes ...

Excel date to Unix timestamp

Does anyone know how to convert an Excel date to a correct Unix timestamp?

C# GemBox Excel Import Error

I am trying to import an excel file into a data table using GemBox and I keep getting this error: Invalid data value when extracting to DataTable at SourceRowIndex: 1, and SourceColumnIndex: 1. As ...

Importing from excel "applications" using SSIS

I am looking for any tips or resources on importing from excel into a SQL database, but specifically when the information is NOT in column and row format. I am currently doing some pre-development ...

热门标签