Java Code Examples for org.apache.poi.hssf.usermodel.HSSFWorkbook#getSheetName()

The following examples show how to use org.apache.poi.hssf.usermodel.HSSFWorkbook#getSheetName() . You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.

Example 1

Source File: ExportToExcelManager.java From ermasterr with Apache License 2.0

6 votes

private int countSheetFromTemplate(final HSSFWorkbook workbook, final ERDiagram diagram) {
    int count = 0;

    for (int sheetNo = 0; sheetNo < workbook.getNumberOfSheets(); sheetNo++) {
        final String templateSheetName = workbook.getSheetName(sheetNo);

        final AbstractSheetGenerator sheetGenerator = getSheetGenerator(templateSheetName);

        if (sheetGenerator != null) {
            count += sheetGenerator.count(diagram);

        } else {
            count++;
        }
    }

    if (exportExcelSetting.isPutERDiagramOnExcel()) {
        count += 1;
    }

    return count;
}

Example 2

Source File: TriggerSheetGenerator.java From ermasterr with Apache License 2.0

6 votes

@Override
public void generate(final ProgressMonitor monitor, final HSSFWorkbook workbook, final int sheetNo, final boolean useLogicalNameAsSheetName, final Map<String, Integer> sheetNameMap, final Map<String, ObjectModel> sheetObjectMap, final ERDiagram diagram, final Map<String, LoopDefinition> loopDefinitionMap) throws InterruptedException {

    for (final Trigger trigger : diagram.getDiagramContents().getTriggerSet()) {
        final String name = trigger.getName();
        final HSSFSheet newSheet = createNewSheet(workbook, sheetNo, name, sheetNameMap);

        final String sheetName = workbook.getSheetName(workbook.getSheetIndex(newSheet));
        monitor.subTaskWithCounter("[Trigger] " + sheetName);

        sheetObjectMap.put(sheetName, trigger);

        setTriggerData(workbook, newSheet, trigger);
        monitor.worked(1);
    }
}

Example 3

Source File: SequenceSheetGenerator.java From ermasterr with Apache License 2.0

6 votes

@Override
public void generate(final ProgressMonitor monitor, final HSSFWorkbook workbook, final int sheetNo, final boolean useLogicalNameAsSheetName, final Map<String, Integer> sheetNameMap, final Map<String, ObjectModel> sheetObjectMap, final ERDiagram diagram, final Map<String, LoopDefinition> loopDefinitionMap) throws InterruptedException {

    for (final Sequence sequence : diagram.getDiagramContents().getSequenceSet()) {
        final String name = sequence.getName();

        final HSSFSheet newSheet = createNewSheet(workbook, sheetNo, name, sheetNameMap);

        final String sheetName = workbook.getSheetName(workbook.getSheetIndex(newSheet));
        monitor.subTaskWithCounter("[Sequence] " + sheetName);

        sheetObjectMap.put(sheetName, sequence);

        setSequenceData(workbook, newSheet, sequence, diagram);
        monitor.worked(1);
    }
}

Example 4

Source File: IndexSheetGenerator.java From ermasterr with Apache License 2.0

6 votes

@Override
public void generate(final ProgressMonitor monitor, final HSSFWorkbook workbook, final int sheetNo, final boolean useLogicalNameAsSheetName, final Map<String, Integer> sheetNameMap, final Map<String, ObjectModel> sheetObjectMap, final ERDiagram diagram, final Map<String, LoopDefinition> loopDefinitionMap) throws InterruptedException {
    clear();

    for (final ERTable table : diagram.getDiagramContents().getContents().getTableSet()) {
        if (diagram.getCurrentCategory() != null && !diagram.getCurrentCategory().contains(table)) {
            continue;
        }

        for (final Index index : table.getIndexes()) {
            final String name = index.getName();

            final HSSFSheet newSheet = createNewSheet(workbook, sheetNo, name, sheetNameMap);

            final String sheetName = workbook.getSheetName(workbook.getSheetIndex(newSheet));
            monitor.subTaskWithCounter("[Index] " + sheetName);

            sheetObjectMap.put(sheetName, index);

            setIndexData(workbook, newSheet, index);
            monitor.worked(1);
        }
    }
}

Example 5

Source File: ExportToExcelManager.java From ermaster-b with Apache License 2.0

6 votes

private int countSheetFromTemplate(HSSFWorkbook workbook, ERDiagram diagram) {
	int count = 0;

	for (int sheetNo = 0; sheetNo < workbook.getNumberOfSheets(); sheetNo++) {
		String templateSheetName = workbook.getSheetName(sheetNo);

		AbstractSheetGenerator sheetGenerator = this
				.getSheetGenerator(templateSheetName);

		if (sheetGenerator != null) {
			count += sheetGenerator.count(diagram);

		} else {
			count++;
		}
	}

	return count;
}

Example 6

Source File: TableSheetGenerator.java From ermasterr with Apache License 2.0

5 votes

/**
 * {@inheritDoc}
 */
@Override
public void generate(final ProgressMonitor monitor, final HSSFWorkbook workbook, final int sheetNo, final boolean useLogicalNameAsSheetName, final Map<String, Integer> sheetNameMap, final Map<String, ObjectModel> sheetObjectMap, final ERDiagram diagram, final Map<String, LoopDefinition> loopDefinitionMap) throws InterruptedException {
    clear();

    List<ERTable> nodeSet = null;

    if (diagram.getCurrentCategory() != null) {
        nodeSet = diagram.getCurrentCategory().getTableContents();
    } else {
        nodeSet = diagram.getDiagramContents().getContents().getTableSet().getList();
    }

    for (final ERTable table : nodeSet) {
        String name = null;
        if (useLogicalNameAsSheetName) {
            name = table.getLogicalName();
        } else {
            name = table.getPhysicalName();
        }

        final HSSFSheet newSheet = createNewSheet(workbook, sheetNo, name, sheetNameMap);

        final String sheetName = workbook.getSheetName(workbook.getSheetIndex(newSheet));
        monitor.subTaskWithCounter("[Table] " + sheetName);

        sheetObjectMap.put(sheetName, table);

        setTableData(workbook, newSheet, table);

        monitor.worked(1);
    }
}

Example 7

Source File: ViewSheetGenerator.java From ermasterr with Apache License 2.0

5 votes

@Override
public void generate(final ProgressMonitor monitor, final HSSFWorkbook workbook, final int sheetNo, final boolean useLogicalNameAsSheetName, final Map<String, Integer> sheetNameMap, final Map<String, ObjectModel> sheetObjectMap, final ERDiagram diagram, final Map<String, LoopDefinition> loopDefinitionMap) throws InterruptedException {
    clear();

    List<View> nodeSet = null;

    if (diagram.getCurrentCategory() != null) {
        nodeSet = diagram.getCurrentCategory().getViewContents();
    } else {
        nodeSet = diagram.getDiagramContents().getContents().getViewSet().getList();
    }

    for (final View view : nodeSet) {
        String name = null;
        if (useLogicalNameAsSheetName) {
            name = view.getLogicalName();
        } else {
            name = view.getPhysicalName();
        }

        final HSSFSheet newSheet = createNewSheet(workbook, sheetNo, name, sheetNameMap);

        final String sheetName = workbook.getSheetName(workbook.getSheetIndex(newSheet));
        monitor.subTaskWithCounter("[View] " + sheetName);

        sheetObjectMap.put(sheetName, view);

        setViewData(workbook, newSheet, view);

        monitor.worked(1);
    }
}

Example 8

Source File: ColumnSheetGenerator.java From ermasterr with Apache License 2.0

5 votes

@Override
public void generate(final ProgressMonitor monitor, final HSSFWorkbook workbook, final int sheetNo, final boolean useLogicalNameAsSheetName, final Map<String, Integer> sheetNameMap, final Map<String, ObjectModel> sheetObjectMap, final ERDiagram diagram, final Map<String, LoopDefinition> loopDefinitionMap) throws InterruptedException {
    final String name = getSheetName();
    final HSSFSheet newSheet = createNewSheet(workbook, sheetNo, name, sheetNameMap);

    final String sheetName = workbook.getSheetName(workbook.getSheetIndex(newSheet));

    sheetObjectMap.put(sheetName, new ColumnSet());

    setAllColumnsData(monitor, workbook, newSheet, diagram);
}

Example 9

Source File: XlsDataSet.java From Leo with Apache License 2.0

5 votes

/**
 * Creates a new XlsDataSet object that loads the specified Excel document.
 */
public XlsDataSet(InputStream in) throws IOException, DataSetException {
    _tables = super.createTableNameMap();

    HSSFWorkbook workbook = new HSSFWorkbook(in);
    int sheetCount = workbook.getNumberOfSheets();
    for (int i = 0; i < sheetCount; i++) {
        ITable table = new XlsTable(workbook, workbook.getSheetName(i),
                workbook.getSheetAt(i));
        _tables.add(table.getTableMetaData().getTableName(), table);
    }
}

Example 10

Source File: XlsDataSet.java From Leo with Apache License 2.0

5 votes

/**
 * 从Excel的工作簿中创建XlsDataSet.
 */
@Deprecated
public XlsDataSet(HSSFWorkbook workbook) throws IOException, DataSetException {
    _tables = super.createTableNameMap();

    int sheetCount = workbook.getNumberOfSheets();
    for (int i = 0; i < sheetCount; i++) {
        ITable table = new XlsTable(workbook, workbook.getSheetName(i),
                workbook.getSheetAt(i));
        _tables.add(table.getTableMetaData().getTableName(), table);
    }
}

Example 11

Source File: ExportToExcelManager.java From ermasterr with Apache License 2.0

4 votes

private void initSheetNameMap(final HSSFWorkbook workbook) {
    for (int i = 0; i < workbook.getNumberOfSheets(); i++) {
        final String sheetName = workbook.getSheetName(i);
        sheetNameMap.put(sheetName.toUpperCase(), 0);
    }
}

Example 12

Source File: ExportToExcelManager.java From ermasterr with Apache License 2.0

4 votes

private void createSheetFromTemplate(final ProgressMonitor monitor, final HSSFWorkbook workbook, final ERDiagram diagram, final boolean useLogicalNameAsSheetName) throws InterruptedException {
    initSheetNameMap(workbook);

    int originalSheetNum = workbook.getNumberOfSheets();

    int sheetIndexSheetNo = -1;

    while (originalSheetNum > 0) {
        final String templateSheetName = workbook.getSheetName(0);

        final AbstractSheetGenerator sheetGenerator = getSheetGenerator(templateSheetName);

        if (sheetGenerator != null) {
            sheetGenerator.generate(monitor, workbook, 0, useLogicalNameAsSheetName, sheetNameMap, sheetObjectMap, diagram, loopDefinitionMap);
            workbook.removeSheetAt(0);

        } else {
            if (!isExcludeTarget(templateSheetName)) {
                moveSheet(workbook, 0);
                final HSSFSheet sheet = workbook.getSheetAt(workbook.getNumberOfSheets() - 1);

                sheetObjectMap.put(templateSheetName, new StringObjectModel(templateSheetName));

                if (pictureSheetGenerator != null) {
                    pictureSheetGenerator.setImage(workbook, sheet);
                }

                if (sheetIndexSheetGenerator.getTemplateSheetName().equals(templateSheetName)) {
                    sheetIndexSheetNo = workbook.getNumberOfSheets() - originalSheetNum;

                    String name = sheetIndexSheetGenerator.getSheetName();

                    name = AbstractSheetGenerator.decideSheetName(name, sheetNameMap);

                    monitor.subTaskWithCounter(name);

                    workbook.setSheetName(workbook.getNumberOfSheets() - 1, name);
                } else {
                    monitor.subTaskWithCounter(sheet.getSheetName());
                }

            } else {
                monitor.subTaskWithCounter("Removing template sheet");
                workbook.removeSheetAt(0);
            }

            monitor.worked(1);
        }

        originalSheetNum--;
    }

    if (sheetIndexSheetNo != -1) {
        sheetIndexSheetGenerator.generate(monitor, workbook, sheetIndexSheetNo, useLogicalNameAsSheetName, sheetNameMap, sheetObjectMap, diagram, loopDefinitionMap);
    }
}

Example 13

Source File: HistorySheetGenerator.java From ermasterr with Apache License 2.0

4 votes

/**
 * {@inheritDoc}
 */
@Override
public void generate(final ProgressMonitor monitor, final HSSFWorkbook workbook, final int sheetNo, final boolean useLogicalNameAsSheetName, final Map<String, Integer> sheetNameMap, final Map<String, ObjectModel> sheetObjectMap, final ERDiagram diagram, final Map<String, LoopDefinition> loopDefinitionMap) throws InterruptedException {

    String sheetName = getSheetName();

    final HSSFSheet newSheet = createNewSheet(workbook, sheetNo, sheetName, sheetNameMap);

    sheetName = workbook.getSheetName(workbook.getSheetIndex(newSheet));
    monitor.subTaskWithCounter(sheetName);

    sheetObjectMap.put(sheetName, new StringObjectModel(sheetName));

    setHistoryListData(workbook, newSheet, sheetObjectMap, diagram);
    monitor.worked(1);
}

Example 14

Source File: ExportToExcelManager.java From ermaster-b with Apache License 2.0

4 votes

private void createSheetFromTemplate(IProgressMonitor monitor,
		HSSFWorkbook workbook, ERDiagram diagram,
		boolean useLogicalNameAsSheetName) throws InterruptedException {
	int originalSheetNum = workbook.getNumberOfSheets();

	int sheetIndexSheetNo = -1;

	while (originalSheetNum > 0) {
		String templateSheetName = workbook.getSheetName(0);

		AbstractSheetGenerator sheetGenerator = this
				.getSheetGenerator(templateSheetName);

		if (sheetGenerator != null) {
			sheetGenerator.generate(monitor, workbook, 0,
					useLogicalNameAsSheetName, this.sheetNameMap,
					this.sheetObjectMap, diagram, loopDefinitionMap);
			workbook.removeSheetAt(0);

		} else {
			System.out.println("non sheet generator :  " + templateSheetName);
			if (!isExcludeTarget(templateSheetName)) {
				moveSheet(workbook, 0);
				HSSFSheet sheet = workbook.getSheetAt(workbook.getNumberOfSheets() - 1);

				this.sheetObjectMap.put(templateSheetName,
						new StringObjectModel(templateSheetName));

				this.pictureSheetGenerator.setImage(workbook, sheet);

				if (this.sheetIndexSheetGenerator.getTemplateSheetName()
						.equals(templateSheetName)) {
					sheetIndexSheetNo = workbook.getNumberOfSheets()
							- originalSheetNum;

					String name = this.sheetIndexSheetGenerator
							.getSheetName();

					workbook.setSheetName(workbook.getNumberOfSheets() - 1,
							AbstractSheetGenerator.decideSheetName(name,
									sheetNameMap));
				}

			} else {
				workbook.removeSheetAt(0);
			}

			monitor.worked(1);
		}

		originalSheetNum--;

		if (monitor.isCanceled()) {
			throw new InterruptedException("Cancel has been requested.");
		}
	}

	if (sheetIndexSheetNo != -1) {
		this.sheetIndexSheetGenerator.generate(monitor, workbook,
				sheetIndexSheetNo, useLogicalNameAsSheetName,
				this.sheetNameMap, this.sheetObjectMap, diagram,
				loopDefinitionMap);
	}
}