Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,556,385
Community Members
 
Community Events
184
Community Groups

View File Macro (Excel) - specifying first column or first row

Claudia Dufour
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 11, 2023

I see that there's a way to limit the cells to the last column and row. Is there a similar feature for specifying the first column/row? 

If I want to display C5:H10, is there a way to skip A:B & rows 1-4?

It would also be great to have multiple ranges shown together, such as C5:H10 & K3:L20. 

1 answer

4 votes
Katerina Rudkovskaya _Stiltsoft_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 11, 2023 • edited

Hi @Claudia Dufour,

If it happens so that you have our Table Filter and Charts for Confluence app installed, you may use our new macro – Table Spreadsheet Include.

The first step is to import your existing Excel file to the Table Spreadsheet macro or insert a new Table Spreadsheet macro and add your data, cells’ formulas, etc. from scratch.

The second step is to use the Table Spreadsheet Include macro to present your data in a neat way. The macro allows you to choose the source page, source spreadsheet, source sheet within this spreadsheet and to manually choose the cells’ range that you want to reuse/display (even one cell can be reused without any additional empty cells).

The Table Spreadsheet Include macro can be also wrapped into Table Filter, Chart from Table and other macros for further processing.

Claudia Dufour
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 11, 2023

That app is not available for me to download on our current version of confluence server. IT blocked most of the apps for "security" reasons, so I have had to find less convenient work arounds. If you have a wiki markup work around for the viewxls macro, that would be ideal. 

Like # people like this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events