Node source code for EXCEL

Nuke_Attokurov · June 9, 2023, 7:34am

Dear @AnotherFraudUser , can you please share the source code for a JAVA node Write To an Excel Template.
One task for the workers, you need to implement something similar in Java. To be burned in this time my favorite KNIME will not participate in this project.

AnotherFraudUser · June 9, 2023, 1:41pm

Hi @Nuke_Attokurov
All the source code can be found here:

For the write to template node checkout this:

github.com

AnotherFraud/AF-Excel-Writer/blob/main/org.anotherfraud.excel/src/org/AF/ExcelUtilities/WriteToExcelTemplate/WriteToExcelTemplateXLSXNodeModel.java

package org.AF.ExcelUtilities.WriteToExcelTemplate;


/*
 * This program is free software: you can redistribute it and/or modify
 * Copyright [2021] [Another Fraud]
 * 
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 * 
 * http://www.apache.org/licenses/LICENSE-2.0
 * 
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 * 
 */

This file has been truncated. show original

However I guess you can also just use the normal POI documentation/ examples
…which is most likely more useful then the node specifics in the WriteToExcelTemplate source code:
https://poi.apache.org/components/spreadsheet/quick-guide.html

Nuke_Attokurov · June 14, 2023, 7:12am

Thank you very much. This is exactly what I need.

AnotherFraudUser · June 14, 2023, 6:12pm

Great!
Also for a lot of nodes Nodepit provides a link to the source code e.g.

just go onto the button “Find Source Code”

system · June 21, 2023, 6:12pm

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.