I am currently using the spreadsheet and a manual data entry form for users that currently have a lot of data stored in Excel spreadsheets.
I need to take data and format the data to a date format but only in certain columns (all cells below a certain column). It would be helpful to apply some sort of ID/name or something similar to give cells a unique identifier.
I need to take data and format the data to a date format but only in certain columns (all cells below a certain column). It would be helpful to apply some sort of ID/name or something similar to give cells a unique identifier.
3 Answers, 1 is accepted
0
Hello Jim,
Can you please elaborate what problem you are facing? Are users importing the excel data via the Kendo UI spreadsheet, or directly in the database via the document processing library? Do you want to format all cells in a spreadsheet range?
Regards,Alex Gyoshev
Telerik
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
0
Jim
Top achievements
Rank 1
Rank 1
answered on 01 Mar 2016, 10:25 PM
The users are just copying the data they already have in Excel into the spreadsheet control. From there I am processing it to the server and storing the data in the database.
0
Hello Jim,
Cells have a unique identifier -- their row and column (A1, B3). You can apply a format to a complete column via a range like "A:A" (in which "A" is the name of the column). See the format method of the range object.
Regards,Alex Gyoshev
Telerik
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!