ロードされたExcelファイルのセルA1からA20までの赤い背景色(#ff0000)のセルデータのみを取得したいと思います。
Excel_Libraryの関数を使用してこれを行うことは可能ですか?
Excel_Libraryの「Cell_Read」機能では、セルの値を取得することはできましたが、セルの背景色のプロパティを取得することはできませんでした。
赤い背景色（#ff0000)のセルデータのリストを取得する方法を教えてください。
Hello @hironari masuda
You can refer to this link to see how you can achieve this.
https://www.outsystems.com/forums/discussion/91175/advanced-excel-conditioning-formatting-apply-background-color-to-cell/
Regards
Nikhil Kumar Vijay
Hello, Nikss
Thanks for your answer.
I followed the link, but it was about how to apply a color to the background color of a cell.
The function I want to implement is to get the value of a red cell if one exists in the uploaded Excel file.
I would also like to know how to implement this in ODC, not OutSystems 11.
Have you tried using the Range_Format Action? You can define font styles, including FontColor in Hex. Also, you can set the cell range of a row or column.
Nikhil kumar Vijay
I think Range_Format Action is an action that allows you to define the format within a range.
What I want to achieve is to perform conditional branching based on cell color, such as counting the number of cells with background color from an uploaded Excel file.
I always appreciate your replies.