Skip to Content (Press Enter)
2026-01-14 04-18-30
Hoàng Tú Lê
27Views
1Comments
[Advanced Excel] Advanced Excel - How to remove format from worksheet?
Question
Beginner
Component
Forge
Traditional Web
advanced-excel
Service icon
Advanced Excel (O11)
Forge asset by Carlos Freitas
Application Type
Traditional Web

Hi,

When I do read excel file with Advanced Excel, rows without data will still be processed because they have format like border, background color,... How can I remove the format of the sheet or is there a way for me to read the file without fomat?

0
0
23 Feb 2023
Copy Link
2022-06-20 13-27-24
Tamilarasan S

I Start from the begining

  •  First open the binary data file in " Workbook Open In Binary data" action
  • Second Step is to select the worksheet in "Worksheet select by index" ( If you don't know about the worksheet or name of the work sheet means "Worksheet select by index" action helps you to select the worksheet By index number of that worksheet )
  • After selecting the worksheet, Use "Cell Read by Index " function to read the cell .The purpose of this function is to read the cell and Give the value of that cell ( Text Or Integer )
  • The important thing is make read text to True, So only this action read the text of that cell
0
0
25 Feb 2023
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.