InstantForum 2017-1 FinalStrataFrame Forumhttp://forum.strataframe.net/StrataFrame ForumFri, 18 Sep 2026 02:27:48 GMT20http://forum.strataframe.net/FindPost30387.aspxHi all - <br/><br/>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.&nbsp;<span>:)</span> Of course that means eight out of sixteen are not! :( <br/><br/>The errors I'm seeing are:<br/><ol><li>Specified cast is not valid.</li><li>Syntax error in INSERT INTO statement.&nbsp;</li><li>The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data. <br/></li></ol>I'm getting the idea this is a semi-fragile feature, and perhaps that's why there's so few postings about it? <br/><br/>My questions/cries for help include:<br/><br/><ol><li>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? <br/></li><li>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? <br/></li><li>I plan on using it for Importing, but don't see anything that talks to requirements of the in-coming Excel file, etc.&nbsp;</li></ol><br/>Any help that you all can throw my way is much appreciated!<br/><br/>TIAMon, 31 Oct 2011 10:37:55 GMTAlex Luyandohttp://forum.strataframe.net/FindPost30518.aspxThanks Ivan and <span id="ctl00_ctlContentPlaceHolder_ctl00_ctlTopic_ctlPanelBar_ctlTopicsRepeater_ctl06_lblFullMessage">Gerard... appreciate the recommendations!<br/></span>Mon, 31 Oct 2011 10:37:55 GMTAlex Luyandohttp://forum.strataframe.net/FindPost30502.aspxHi Alex.<br/><br/>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, &nbsp;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.<br/><br/>Regards,<br/><br/>Ger<i>ard</i><br/><br/><i></i>&nbsp;Thu, 27 Oct 2011 11:42:59 GMTGer Cannollhttp://forum.strataframe.net/FindPost30500.aspxHiya.<br/><br/>I use Grapecity's Spread for Windows. <br/><br/>Yep, great product.&nbsp;I got it syncked with SF BusinessBindingSource and am able to save spreadsheet cell&nbsp;formulas to the database.Wed, 26 Oct 2011 16:42:11 GMTIvan George Borgeshttp://forum.strataframe.net/FindPost30495.aspxHi Ivan. <br/><br/>No problem. What do you use? Happy with it? Wed, 26 Oct 2011 11:49:18 GMTAlex Luyandohttp://forum.strataframe.net/FindPost30453.aspxSorry 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.Sat, 22 Oct 2011 08:29:46 GMTIvan George Borgeshttp://forum.strataframe.net/FindPost30451.aspxNobody? :( Fri, 21 Oct 2011 14:59:36 GMTAlex Luyando