Excel to Json ASPX Upload
Hello,
I’m not sure if this is possible. I’m making a Website for my support team using the Twitter Bootstrap framework. (Since I don’t have alot of mad web skills)
What I’m trying to do is create a upload page that a tech can update an excel file (once a month) with data from are Mobile phone vendors. I was hoping that I can find an script that would upload and convert it to a json file that would be located on directory. This way I can use that Json file with the Bootstrap autocomplete function.
Is this possible or should I be looking into something else. TO be honest I just want to get this setup for the team so they can manage it going forward. That why I never have to update or play with the data for them to get the webpage to work.
Example of CVS: >
Sprint;555-444-1111,04/25/
Sprint;555-444-2222,04/25/
AT&T;555-444-3333,04/25/19
And so on….
Note: I'm using IIS 7.5, Domain access only.
I’m not sure if this is possible. I’m making a Website for my support team using the Twitter Bootstrap framework. (Since I don’t have alot of mad web skills)
What I’m trying to do is create a upload page that a tech can update an excel file (once a month) with data from are Mobile phone vendors. I was hoping that I can find an script that would upload and convert it to a json file that would be located on directory. This way I can use that Json file with the Bootstrap autocomplete function.
Is this possible or should I be looking into something else. TO be honest I just want to get this setup for the team so they can manage it going forward. That why I never have to update or play with the data for them to get the webpage to work.
Example of CVS: >
Sprint;555-444-1111,04/25/
Sprint;555-444-2222,04/25/
AT&T;555-444-3333,04/25/19
And so on….
Note: I'm using IIS 7.5, Domain access only.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi,
it depends: if they all use the same template / same structured Excel file and it is at least Excel 2007 file type (.xslx), you might be able to use Office Open XML 2 to open and process the uploaded Excel file and extract the data and store it as CSV (there is no built-in function to "SaveAsCSV") or even directly process the rows/cells to create the JSON file.
Pro: pure .NET with no need to install Excel (client) on the server
HTH
Rainer
it depends: if they all use the same template / same structured Excel file and it is at least Excel 2007 file type (.xslx), you might be able to use Office Open XML 2 to open and process the uploaded Excel file and extract the data and store it as CSV (there is no built-in function to "SaveAsCSV") or even directly process the rows/cells to create the JSON file.
Pro: pure .NET with no need to install Excel (client) on the server
HTH
Rainer
ASKER
This got me going in the right direction. Thanks!
C# CODE TO CONVERT CSV FILE JSON FILE FORMAT
{DELETED LINK TO COMPETING SITE THAT ALSO DID NOT PROVIDE AN CONCLUSIVE ANSWER - tagit (TA)}
hope this helps.