Just noticed your message that the 1st sheet is empty. This may be a reason as well. In some importers index starts with zero. In some, it starts with 1.
Overtime, several different spreadsheet importers were built. Based on our and customer’s experience with them, we are no longer actively maintaining spreadsheet import options unique to TBC. We discovered that no matter how much one tries, there will always be cases when a canned spreadsheet import does not do exactly what a user needs - because of how a particular spreadsheet is structured and the data in it and/or because a canned import is not fully aligned with the user’s unique needs. Spreadsheet importer available in EDG is under active maintenance. This is the only pre-canned option under active maintenance. All other options are as-is. For use cases that are outside of the current capabilities of that importer, we recommend and made available facilities for scripting a custom import as explained in https://www.datashapes.org/active/import.html#spreadsheets Also see the video https://www.topquadrant.com/project/importing-data-using-active-data-shapes/ > On Sep 16, 2021, at 11:25 AM, Irene Polikoff <[email protected]> wrote: > > Yes, index starts with 0 > > >>> On Sep 16, 2021, at 10:23 AM, 'Bohms, H.M. (Michel)' via TopBraid Suite >>> Users <[email protected]> wrote: >>> >> >> More info: >> It only goes wrong when the first sheet is empty >> If there is data classification is fine. >> >> >> Dr. ir. H.M. (Michel) Bohms >> Scientist Specialist >> Structural Reliability >> T +31 (0)88 866 31 07 >> M +31 (0)63 038 12 20 >> E [email protected] >> Location >> >> >> <image003.gif> >> This message may contain information that is not intended for you. If you >> are not the addressee or if this message was sent to you by mistake, you are >> requested to inform the sender and delete the message. TNO accepts no >> liability for the content of this e-mail, for the manner in which you use it >> and for damage of any kind resulting from the risks inherent to the >> electronic transmission of messages. >> >> Van: 'Bohms, H.M. (Michel)' via TopBraid Suite Users >> <[email protected]> >> Verzonden: Thursday, September 16, 2021 12:54 PM >> Aan: [email protected] >> Onderwerp: [topbraid-users] third issue sheet import >> >> In excel i have 3 sheets >> 1 en 3 are empty, 2 is filled: >> >> <image004.png> >> >> Result: >> Data from sheet 2 is classified as sheet no 1 .. >> >> <image005.png> >> >> Is this expected? >> >> Thx Michel >> >> >> >> >> Dr. ir. H.M. (Michel) Bohms >> Scientist Specialist >> Structural Reliability >> T +31 (0)88 866 31 07 >> M +31 (0)63 038 12 20 >> E [email protected] >> Location >> >> >> <image003.gif> >> This message may contain information that is not intended for you. If you >> are not the addressee or if this message was sent to you by mistake, you are >> requested to inform the sender and delete the message. TNO accepts no >> liability for the content of this e-mail, for the manner in which you use it >> and for damage of any kind resulting from the risks inherent to the >> electronic transmission of messages. >> >> -- >> You received this message because you are subscribed to the Google Groups >> "TopBraid Suite Users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/topbraid-users/d0148d90da724fd2889e6100f25fa6b2%40tno.nl. >> -- >> You received this message because you are subscribed to the Google Groups >> "TopBraid Suite Users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/topbraid-users/d4e75bb24ee0414db65532e6a77e375a%40tno.nl. -- You received this message because you are subscribed to the Google Groups "TopBraid Suite Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/DE421DE1-5D21-4FAE-A2F0-823208A4A0AC%40topquadrant.com.
