The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

darpan13's avatar
darpan13
Contributor
4 years ago

Insert Rows using Spread sheet

SOURCE: ONESTREAM CHAMPIONS

Hi Friends,

Did anyone try inserting rows into a custom table ( within one stream ) using Spread Sheet?

I am able to update the data into the custom table, but somehow the basic functions like insert didn’t work for me.

I need a similar function as per the screenshot for identifying the new records and the existing records.

 

https://discourse-static.influitive.net/uploads/db_8467a788_7b9e_45b8_8b6c_d37e1967220d/original/1X/1c5dee15c2a1bb8d86b5682de4f4220b3122a2bd.png
Expectation in SS.png966×362 20.1 KB

 

Regards and Thanks

Darpan Bhansali

Excel Add In

4 Replies

    • ckattookaran's avatar
      ckattookaran
      Valued Contributor
      4 years ago

      You need to create the spreadsheet rule that allows inserting. You can enable how many insert rows need to be provided as well. I use the status column feature to perform INSERT, UPDATE, and DELETE operations.

      • darpan13's avatar
        darpan13
        Contributor
        4 years ago

        Hi Celvin, thanks… i can understand what you spoke above… but unable to write the code… if possible can you please share the code which you used.

        that will be of great help

        Regards

        Darpan Bhansali

    • Dominic_A's avatar
      Dominic_A
      Icon for OneStream Employee rankOneStream Employee
      4 years ago

      Hi,
      do you have the “Table Views User Guide” available?
      On page 14 there is an example helper similar to his code:
      Dim tableView As New TableView()
      tableView.CanModifyData = True
      tableView.NumberOfEmptyRowsToAdd = 5
      tableView.EmptyRowsBackgroundColor = XFColors.LightGray
      The addition of tableview.EnableStatusColumn(True, statusColumnName, “DELETE,ARCHIVE, INACTIVE”) is described on the following pages of the same guide.
      The final area is where the operations could be set

      https://discourse-static.influitive.net/uploads/db_8467a788_7b9e_45b8_8b6c_d37e1967220d/original/1X/7fe486870e27278a862be65cd033c4e539286f93.png
      image.png693×361 5.39 KB

       

      If the statusColumnName is not declared there is an automated/default naming of that column when left blank. “DELETE, ARCHIVE, INACTIVE” could show those choices in the drop down of the Spreadsheet Table View. A key requirement is to set ‘CanModifyData’ to True.

      For the exact code combination that needs to be associated with status in your case, I will leave this question to your service providers