//create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); // Prepare data // Skew matrix generator // Input: // DegX135 // DegY45 // // Output: // M11 1 M12 1 // M21 -1 M22 1 // M31 0 M32 0 worksheet.getRange("B1").setValue("Skew matrix generator"); worksheet.getRange("A2:A4").setValue(new String[] {"Input:", "DegX", "DegY"}); worksheet.getRange("B3").setValue(135); worksheet.getRange("B4").setValue(45); worksheet.getRange("A6").setValue("Output:"); worksheet.getRange("A7:A9").setValue(new String[] {"M11", "M21", "M31"}); worksheet.getRange("B7").setValue(1); worksheet.getRange("B8").setFormula("=TAN(B3/180*3.14)"); worksheet.getRange("B9").setValue(0); worksheet.getRange("C7:C9").setValue(new String[] {"M12", "M22", "M32"}); worksheet.getRange("D7").setFormula("=TAN(B4/180*3.14)"); worksheet.getRange("D8").setValue(1); worksheet.getRange("D9").setValue(0); // Replace 3.14 with PI() IRange searchRange = worksheet.getUsedRange(); searchRange.replace(3.14, "PI()"); // Replace M with m (Match case) ReplaceOptions tempVar = new ReplaceOptions(); tempVar.setMatchCase(true); searchRange.replace("M", "m", tempVar); // Replace m11 with M11 (Match whole word, match byte) ReplaceOptions tempVar2 = new ReplaceOptions(); tempVar2.setLookAt(LookAt.Whole); tempVar2.setMatchByte(true); searchRange.replace("m11", "M11", tempVar2); //save to an excel file workbook.save("ReplaceWithOptions.xlsx");
//create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) // Prepare data // Skew matrix generator // Input: // DegX135 // DegY45 // // Output: // M11 1 M12 1 // M21 -1 M22 1 // M31 0 M32 0 worksheet.getRange("B1").value = "Skew matrix generator" worksheet.getRange("A2:A4").value = arrayOf("Input:", "DegX", "DegY") worksheet.getRange("B3").value = 135 worksheet.getRange("B4").value = 45 worksheet.getRange("A6").value = "Output:" worksheet.getRange("A7:A9").value = arrayOf("M11", "M21", "M31") worksheet.getRange("B7").value = 1 worksheet.getRange("B8").formula = "=TAN(B3/180*3.14)" worksheet.getRange("B9").value = 0 worksheet.getRange("C7:C9").value = arrayOf("M12", "M22", "M32") worksheet.getRange("D7").formula = "=TAN(B4/180*3.14)" worksheet.getRange("D8").value = 1 worksheet.getRange("D9").value = 0 // Replace 3.14 with PI() val searchRange = worksheet.usedRange searchRange.replace(3.14, "PI()") // Replace M with m (Match case) val tempVar = ReplaceOptions() tempVar.matchCase = true searchRange.replace("M", "m", tempVar) // Replace m11 with M11 (Match whole word, match byte) val tempVar2 = ReplaceOptions() tempVar2.lookAt = LookAt.Whole tempVar2.matchByte = true searchRange.replace("m11", "M11", tempVar2) //save to an excel file workbook.save("ReplaceWithOptions.xlsx")