our company is using FlexCel to give our customers the possibility to create Excel- and PDF based reports. Since our customers can create reports on their own, we need to validate the excel file before the report is created. Our biggest problem is checking the availability of named ranges. We need 1 named range per SQL-Query. The problem is, how to find out if the query is used. There has to be a cell content like "<#query.column>". But to find out if a query is used, thus if to check if the respective named range is given, we need to find out if there is a cell with a content like "<#query.column>". My first idea was to check every cell in the excel document, but I think this isn't a reasonable option. Can you tell me if it is possible to look for a specific cell content without checking every cell? Or maybe do you have any other ideas to solve our problem?
Thanks in advance
There is not much I can suggest here. The first thing is, that FlexCel does validation by itself when running the report. Reporting actually has 2 stages: The first is a "compilation" phase where the tags are read and parsed into executable objects, and the second stage is where the "compiled" report is run. Any typo in ids or tags outside the range will be caught in the compilation phase.
Yes it is true, but in the worst case the customer has a cell content like "<#query.data>" and has forgotten to provide the named range "query". In order to prevent an error message from FlexCel in this case, I have to search for such content and check, if it is in the proper named range. But thank you for your advice. It seems that I have to look in every cell in this worst case.