IWorksheet - Sheet content manager
IWorksheet
is an interface to manage cells content.
IWorksheet
depends on IWorkbook
instance. From the worksheet object you can get the fallowing information: worksheet ID, name, hidden state.
Example:
import com.intechcore.scomponents.scell.api.IScellApiResolver;
import com.intechcore.scomponents.scell.api.init.ScellApiEntryPoint;
import com.intechcore.scomponents.scell.api.spreadsheet.IScellCoreApiFactory;
import com.intechcore.scomponents.scell.api.spreadsheet.model.IWorkbook;
import com.intechcore.scomponents.scell.api.spreadsheet.model.IWorksheet;
import com.intechcore.scomponents.scell.api.spreadsheet.service.builder.IRangeAddressBuilder;
public class CustomerExamples {
public static void main(String[] args) {
ScellApiEntryPoint.getApiResolverAsync().thenAccept(resolver -> {
IScellCoreApiFactory coreApiProvider = resolver.resolve(IScellCoreApiFactory.class); // core API entry point
IWorkbook newWorkbook = coreApiProvider.createNew(); // new spreadsheet
IWorksheet worksheet = newWorkbook.getFirst(); // getting first worksheet
int worksheetID = worksheet.getId(); // worksheet ID
String worksheetName = worksheet.getName(); // worksheet name
boolean isHidden = worksheet.isHidden(); // worksheet's hidden state
IRangeAddressBuilder addressBuilder = resolver.resolve(IRangeAddressBuilder.class); // getting IRangeAddressBuilder to make content calls
worksheet.inputContent(addressBuilder.setTopLeft(1, 1).buildCell(), "2022-12-12"); // set content into A1 cell
}).whenComplete((unused, throwable) -> {
if (throwable != null) {
System.out.println(throwable.getMessage());
}
}).join();
}
}