function main(workbook: ExcelScript.Workbook) {
let selectedSheet = workbook.getActiveWorksheet();
// G:H 열에서 마지막 행을 찾아 소수점 3자리로 포맷
let usedRange = selectedSheet.getRange("G:H").getUsedRange();
let lastRow = usedRange.getRowCount();
// 마지막 행까지의 범위를 지정하여 포맷 적용
selectedSheet.getRange(G2:H${lastRow + 1}).setNumberFormatLocal("#,##0.000");
}
10/09/2024
Excel 365에서 소수3째자리 변경 Excel script source
Subscribe to:
Post Comments (Atom)
Featured Post
php db connect
<?php echo "Hello world!" ; $server_name = "localhost" ; $user = "root" ; $password = "" ; ...
Popular Posts
-
Chocolate coating solutions can vary based on the specific application and desired characteristics. Here are some common types of chocolate ...
-
Coating chocolate using methods like panning involves careful temperature control throughout the processing period to achieve the desired r...
-
An enrober is a specialized machine widely used in the confectionery industry for coating various food items, most commonly with chocolate. ...
No comments:
Post a Comment