SpreadsheetSplitter
Inheritance: java.lang.Object
public class SpreadsheetSplitter
Splits spreadsheet file into multiple parts.
Example
SpreadsheetSplitter.process("template.xlsx", "split.xlsx");
Methods
| Method | Description |
|---|---|
| equals(Object arg0) | |
| getClass() | |
| hashCode() | |
| notify() | |
| notifyAll() | |
| process(LowCodeSplitOptions options) | Splits spreadsheet file into multiple parts. |
| process(String templateFile, String resultFile) | Splits given template file into multiple parts. |
| toString() | |
| wait() | |
| wait(long arg0) | |
| wait(long arg0, int arg1) |
equals(Object arg0)
public boolean equals(Object arg0)
Parameters:
| Parameter | Type | Description |
|---|---|---|
| arg0 | java.lang.Object |
Returns: boolean
getClass()
public final native Class<?> getClass()
Returns: java.lang.Class
hashCode()
public native int hashCode()
Returns: int
notify()
public final native void notify()
notifyAll()
public final native void notifyAll()
process(LowCodeSplitOptions options)
public static void process(LowCodeSplitOptions options)
Splits spreadsheet file into multiple parts.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| options | LowCodeSplitOptions | Options for splitting spreadsheet |
process(String templateFile, String resultFile)
public static void process(String templateFile, String resultFile)
Splits given template file into multiple parts.
Remarks
The output files will be build from the specified resultant file by appending sequence number of the sheet and split part. For example, if the specified output file is Split.xlsx, then the generated files will be Split_0_0.xlsx, Split_0_1.xlsx, …, Split_1_0.xlsx, …
Parameters:
| Parameter | Type | Description |
|---|---|---|
| templateFile | java.lang.String | The template file to be split |
| resultFile | java.lang.String | The resultant file(name pattern) |
toString()
public String toString()
Returns: java.lang.String
wait()
public final void wait()
wait(long arg0)
public final native void wait(long arg0)
Parameters:
| Parameter | Type | Description |
|---|---|---|
| arg0 | long |
wait(long arg0, int arg1)
public final void wait(long arg0, int arg1)
Parameters:
| Parameter | Type | Description |
|---|---|---|
| arg0 | long | |
| arg1 | int |