Giter VIP home page Giter VIP logo

pancakespreadsheet's Introduction

PancakeSpreadsheet

Grasshopper plugin for reading/writing xls(x) files without Excel, based on NPOI.

This is more stable and reliable than the COM approach and is cross-platform.

See the project on Food4Rhino

Future plan

  • Provides access to Google Spreadsheet, Airtable, etc. It can be done by implementing custom classes with NPOI interface IWorkbook to provide a unified access approach.

pancakespreadsheet's People

Contributors

karakasa avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar

pancakespreadsheet's Issues

Pick and apply a cell style? HowTo?

Do you also have an example how I can apply a cell style from existing spreadsheet to a new created set of cells? I want to apply the style Labeled CNC or BSAW or MT from the cell A5 to the cells nr.5 of the created cuttinglist.

Style_choose

Style_choose.xlsx

Best regards.

Spreadsheet object custom id, to create unique objects per export.

Hi karakasa, thank you so much for the incredible plugin! It's significantly faster than all the other available options, and it's fantastic that it doesn't rely on Excel itself.

I was wondering if there is a way to create a new spreadsheet object each time I want to save it. Perhaps adding a name or ID as an optional input would be helpful. Currently, I'm using the plugin to export custom XLSX files with different names, but the create object function remembers the first object and appends to it. As a result, I ended up with an incorrect XLSX export.

Thanks,in advance

'Format as table' can cause errors when reading a sheet

It appears that the plugin fails to read the sheet range or sheets themselves correctly when I format cells as table.
afbeelding

This is a sample table that caused the issues when I formatted it:
afbeelding

When I remove this formatting and leave the cells as plain text or simple sum() formula, the sheets and data read fine.

[Feature request] Auto-refresh data when the referenced Excel file is saved

Would it be possible to detect changes to the Excel sheet with the "Open Spreadsheet" component when OK is said to true? Ideally, when set to proceed reading the sheet, I would like it to dynamically pull the new data from Excel when I made changes to the file. That saves me from going back to the component to hit the Boolean Toggle for the OK input on every file save. Perhaps this could be an option in the right click menu like with Elefront, where you can set auto-update for the component to true or false in this list:
afbeelding

Generate data in multiple cells?

Hi. Please can you provide a sample on how I can pass the information from Grasshopper tree into "Set Multiple Cells" component because seems that nothing that I tried works.

I do have a list with branches that contains 5 indices like this:

Pancake_Sheet_create_multiple_cells

The 5th element it's a separator. It is a long list and I do need to split in multiple columns to fit an A4 page paper into the xlsx file. Basically I want to create an excel spreadheet to feed all this information and create some labels.

I want to split the content in three or four colums to fit the content into the cells like in this page template:

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.