You’re offline. This is a read only version of the page.
Hello Everyone,
Good day!
I have an excel file in SharePoint and I would like to seek your help regarding:
- Is there anyway I can create table from excel data which is in rows. Which means the excel data value does was not in table format.
Is there any way to do this? Thanks in advance for your help.
If you are asking is there a way to make the table adjust based on how many rows are in the spreadsheet, then the answer is no there isn't. What I've always had to do was create the table larger than I expect it to ever be. and then filter out empty rows when I use the table later.
Hi @Pstork1 ,
I have tried this one. The Range I set did set is $A1:$G7 but what if the $G7 is dynamic? how to do that?
There is an action that will let you create a table in an existing Excel Spreadsheet based on a range of cells you provide. You can also name the table and specify the column header names.
#1
Michael E. Gernaey
497
Super User 2025 Season 2
#2
David_MA
436
Super User 2025 Season 2
#3
Riyaz_riz11
244
Super User 2025 Season 2
Share
Report
All responses (
Answers (
