We have spreadsheet-based reports (plain, tabular formats) that are
sent out from our data warehouse on a daily basis. I have them
being caught in a public folder and routed to a document library.
Rather than having users reference the Excel reports directly, our
executives would prefer to see multiple, professional-looking data
views with a "dashboard" type of look.
We have the views all built and have been hand-loading the data sets
each morning using copy and paste (ugh). We're also working with IT
on a longer-term solution to make the data storage / retrieval more
efficient and eliminate manual work.
In the mean time, one of our developers is working on an event
handler that will trigger when a new report arrives. The event
handler will read the contents of the file and synchronize the
changes with the corresponding list (as identified in a
configuration list).
He's running into problems with his approach when he encounters
cells in the spreadsheet with null values, though. We would like to
ask around to see if anyone has done something similar (and overcome
this issue), has ideas to either make this approach work or can
suggest a different approach.
Here's what the developer says, "
I am using the Excel object in my application, the scenario is I am
getting all the cell values in a 2 dimensional array object and
inserting those values cell by cell into a Sharepoint list.
The problem I face is, when there is an empty cell value i am not
able to check that cell with "NULL" or "EMPTY' in the c# code. The
program stops at that cell and I get dotnet Null value exception.
But I can see the value of that cell in my Dev. tool, as <Undefined
value> in the debugger windows."