☝️Small business or a startup? See if you qualify for our special offer.
+
Get Free Trial
Get Free Trial

Question about paste values from a spreadsheet directly in grid

posted on May 21st, 2025

Answered
Gilberto Nishioka asked on May 21, 2025

My name is Gilberto, and I’m working in an Angular project where pivot table functionality is essential.

So, we are analyzing several components, and after navigating in FlexMonster’s website, your component meets almost all the demands of our users.

But one specific requirement remains:

  • Does FlexMonster allow a user to copy some data from a spreadsheet and batch update existing data in a grid?

Following is an example to illustrate this situation:

----------------------------------------------------------

  1. The application shows a grid with some data:

Column A    Column B

1                             10

2                             10

3                             10

4                             10

 

  1. Then the user copy and paste this data into a spreadsheet and alter the values:

(Spreadsheet)

Column A    Column B

1                             10

2                             20

3                             30

4                             40

 

  1. And finally, the user copies the spreadsheet column B's data and paste in the application (column B of the grid):

(Application)

Column A    Column B

1                                             10

2                                             20

3                                             30

4                                             40

----------------------------------------------------------

 Thanks in advance!

5 answers

Public
Solomiia Andrusiv Solomiia Andrusiv ⋅ Flexmonster ⋅ May 22, 2025

Hello, Gilberto!

Thank you for reaching out to us.

Kindly note that Flexmonster is mainly designed to visualize the data from the specified data source, and has limited functionality to perform CRUD operations with flat data on the run.
Our team recommends the following approach for the described use case:

  • paste data from Flexmonster to the spreadsheet
  • modify the data on the spreadsheet and save the CSV file to the local system
  • using Connect Toolbar tab, open the CSV file, and all results will be reflected on the grid with no need for further customizations.

Alternatively, it is possible to add custom controls for user input outside of Flexmonster and use the updateData() API call to refresh the data on the grid.

If you need to update a few values ​​point by point without changing the entire column on the flat table, you can enable editing, as discussed in the following thread: https://www.flexmonster.com/question/when-calling-flexmonster-save/.

Do not hesitate to ask if you have any further questions.
Looking forward to hearing from you.

Best regards,
Solomiia

Public
Solomiia Andrusiv Solomiia Andrusiv ⋅ Flexmonster ⋅ May 29, 2025

Hello, Gilberto!

Hope you are having a great week.

Just checking in to ask if the described approach to refresh CSV data in Flexmonster after editing it in spreadsheets works for your case.

Looking forward to hearing your feedback.

Best regards,
Solomiia

Public
Solomiia Andrusiv Solomiia Andrusiv ⋅ Flexmonster ⋅ June 5, 2025

Hello, Gilberto!

Hope you are doing well.

Our team is wondering if you have any further questions about Flexmonster. Our team would be happy to assist you with any questions you may have.

Looking forward to hearing from you.

Kind regards,
Solomiia

Public
Gilberto Nishioka ⋅ 2 days ago 
Hello, Solomila.

Sorry for the delay in replying.

Yes, your instructions helped us a lot to clarify how to use the FlexMonster component in this case, but the proposed solution would change a lot the way our users work.

Since implementing all the clipboard control has a significant impact on our work schedule, we are checking if other libraries can attend our user's demands...

Although FlexMonster is designed to visualize data, would there be a possibility in the future to incorporate this type of operation in FlexMonster (pasting existing data from the clipboard directly into the grid)?

Thank you for your excellent support!

 

Public
Maksym Diachenko Maksym Diachenko ⋅ Flexmonster ⋅ 23 hours ago

Hello, Gilberto!

Thank you for your feedback.
Our team will let you know if we intend to support copying data from Excel to Flexmonster in the future. Feel free to contact us if more questions arise.

Best regards,
Maksym

Please login or Register to Submit Answer