StrataFrame Forum
Back
Login
Login
Home
»
StrataFrame Application Framework - V1
»
WinForms (How do I?)
»
ExcelHelper questions
ExcelHelper questions
Post Reply
Like
0
ExcelHelper questions
View
Flat Ascending
Flat Descending
Threaded
Options
Subscribe to topic
Print This Topic
RSS Feed
Goto Topics Forum
Author
Message
Alex Luyando
Alex Luyando
posted 13 Years Ago
ANSWER
Topic Details
Share Topic
Group: StrataFrame Users
Posts: 112,
Visits: 1.2K
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
________________
_____/ Regards,
____/ al
Reply
Like
0
GO
Merge Selected
Merge into selected topic...
Merge into merge target...
Merge into a specific topic ID...
Open Merge
Threaded View
Threaded View
ExcelHelper questions
Alex Luyando
-
13 Years Ago
Nobody? :(
Alex Luyando
-
13 Years Ago
Sorry Alex, I have not touched this component. I use a third-party one...
Ivan George Borges
-
13 Years Ago
Hi Ivan. No problem. What do you use? Happy with it?
Alex Luyando
-
13 Years Ago
Hiya. I use Grapecity's Spread for Windows. Yep, great product.I...
Ivan George Borges
-
13 Years Ago
Hi Alex. I've used a tool from GemBox in a number of different...
Ger Cannoll
-
13 Years Ago
Thanks Ivan and Gerard... appreciate the recommendations!
Alex Luyando
-
13 Years Ago
Post Reply
Like
0
Similar Topics
Post Quoted Reply
Reading This Topic
Login
Login
Remember Me
Reset Password
Resend Validation Email
Login
Explore
Messages
Mentions
Search