By Alex Luyando - 10/3/2011
Hi all -
Starting to work with the ExcelHelper to export to (and eventually import from) Excel-formatted files. So far it's a glass half full/half empty situation for me--literally! I've setup a generic user control to use on my StrataFrame forms to provide export and other capabilities, and eight out of sixteen BOs are successfully exported.  Of course that means eight out of sixteen are not! 
The errors I'm seeing are:
- Specified cast is not valid.
- Syntax error in INSERT INTO statement.
- The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.
I'm getting the idea this is a semi-fragile feature, and perhaps that's why there's so few postings about it?
My questions/cries for help include:
- I was looking to trace into the ExcelHelper to determine the exact BO row/column that it finds offensive, but don't see the code... How do I get it? I have the StrataFrame source code and have traced into it on occasion; is this a separate distribution or not distributed?
- Looked in the StrataFrame help, but only see basic info there; nothing I could use to help troubleshoot this. Any place to get help on this?
- I plan on using it for Importing, but don't see anything that talks to requirements of the in-coming Excel file, etc.
Any help that you all can throw my way is much appreciated!
TIA
|
By Alex Luyando - 10/21/2011
Nobody?
|
By Ivan George Borges - 10/22/2011
Sorry Alex, I have not touched this component. I use a third-party one to deal with Excel and spreadsheets. Hopefuly someone else will jump in and give you some feedback.
|
By Alex Luyando - 10/26/2011
Hi Ivan.
No problem. What do you use? Happy with it?
|
By Ivan George Borges - 10/26/2011
Hiya.
I use Grapecity's Spread for Windows.
Yep, great product. I got it syncked with SF BusinessBindingSource and am able to save spreadsheet cell formulas to the database.
|
By Ger Cannoll - 10/27/2011
Hi Alex.
I've used a tool from GemBox in a number of different projects and found it quite easy to use. Before that (IN VFP) had been automating Excel, but Gembox does not require Excel to be installed, and is also about 10 times faster than automation. Had all the functionality I required to create Excel Files , Multiple Sheets within a file etc. As far as I can remember it cost around $300 . I have not tried it yet directly with SF, just from datasets/ commands.
Regards,
Gerard
|
By Alex Luyando - 10/31/2011
Thanks Ivan and Gerard... appreciate the recommendations!
|