Spreadsheet Import Tool

[pturmel]

Now in the Ignition Exchange.

While waiting on IA review, i Interested parties can also get this here:

https://www.automation-pros.com/SpreadsheetImportTool/

I intend to publish at this link as well as in the Exchange going forward.

Announcements will be in this topic. (:

[msteele]

Thanks for your work on this and publishing it for the community.

[jlandwerlen]

Had a chance to poke around at this today, it's a nice tool Phil, thanks for sharing.

[pturmel]

Now published:

Ignition Exchange

[Mitesh_Maniar]

Hello,
can anyone please give brief explanation about use of this tool and benefits ? thanks for all your help.

[pturmel]

I answered your question over here:

Do's and Don'ts when developing First Project with Ignition?

Many Ignition applications/deployments use many device connections with corresponding UDT instances, or with large collections of UDT instances, or with a mix of UDTs and arbitrary tags and tag folders. It is common for there to be repeating patterns for most of this, but with enough odd elements for Ignition's instance creation wizard to be unsuited. (Well, the wizard is awfully simplistic--I never use it.) With this tool, you can create structures in an Excel workbook that describes all of …

Reposting questions in more than one place is against this forum's rules.

[Kyle_Carter]

I was about to go through the process of putting my version of this on Exchange. this one is much nicer though haha

[pturmel]

[msteele]

Feature request: After the file is selected and handled by Apache POI but before the workbook is processed, list the sheets within the workbook and allow the user to select/de-select sheets for processing.

[pturmel]

Hmmm. Challenging idea. Will consider how to do that.

[msteele]

For anyone at ICC next week, I'll be leading a table talk on Tuesday 9/17 at 9:45 a.m. which will include a discussion about the flexibility and power of this tool within our workflow.

[pturmel]

@msteele

table talk on Tuesday 9/17 at 9:45 a.m.

I plan to be there to answer related questions.

[Steve_Laubach]

I plan to be there with a colleague (also named Phil). Looks like a fantastic tool.

We look forward to meeting you. You're a living legend.

[msteele]

Prepping a demo from a table by the pavilion while waiting for the registration line to die down. Feel free to stop by and say hi, or join us at 9:45 a.m. PDT in the pavilion to hopefully see how this works.

[michael.flagler]

Great table talk! Really enjoyed it!

[jlandwerlen]

Phil helped me on the side today... updating this topic in case it helps others.

I have a unique tag/naming structure and was trying to separate into logical chunks to take advantage of local variables/% string formatting options. The part that was unique was two characters and started with a number. One cell value was 1F, which is parseable as a number, thus would evaluate as 1.0 not 1F, which is not what I wanted. For me, there wasn't an option to rename or not start with a number, so Phil suggested using eval().

I had a column named ID, I renamed this column to IDraw and added a leading underscore to the value(s). You could also add a space or other character that you see fit. Next I added a column to the right of ID, named IDEval and the cell value was IDraw.strip("_"). From my testing, IDEval can't be blank.