Can you create a table directly using EXCEL?

[__ _12]

hi！

Can I use EXCEL to create a table, customize the type of fields in it, upload it to the project, and get a table?

[Community Alums · Accepted solution]

Hi,

You can write an onBefore Transform Script in your Transform Map to read the table names and column names from the Excel file.

You can find more details about table generation from scripts here: https://community.servicenow.com/community?id=community_question&sys_id=a3cc8329db9cdbc01dcaf3231f96...

Mark my answer correct & Helpful, if Applicable.

Thanks,
Sandeep

[__ _12]

I am a newbie. . . . .
Is there any reference code
I would like to know how to get the Excel file and the rows and columns inside.
Many thanks!

[__ _12]

一图胜千言！

[Kalyani Jangam1]

Hi, By using transform map it possible, Please refer below docs for more details

https://developer.servicenow.com/dev.do#!/learn/learning-plans/quebec/new_to_servicenow/app_store_learnv2_importingdata_quebec_create_a_transform_map