org.eclipse.birt.report.engine.emitter.excel.ExcelWriter Maven / Gradle / Ivy

Show more of this group Show more artifacts with this name
Show all versions of org.eclipse.birt.runtime Show documentation
A component of the BIRT runtime
There is a newer version: 4.6.0-20160607
Show newest version
/*******************************************************************************
 * Copyright (c) 2008 Actuate Corporation.
 * All rights reserved. This program and the accompanying materials
 * are made available under the terms of the Eclipse Public License v1.0
 * which accompanies this distribution, and is available at
 * http://www.eclipse.org/legal/epl-v10.html
 *
 * Contributors:
 *  Actuate Corporation  - initial API and implementation
 *******************************************************************************/

package org.eclipse.birt.report.engine.emitter.excel;

import java.io.BufferedReader;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStreamReader;
import java.util.HashMap;
import java.util.Map;
import java.util.UUID;

import org.eclipse.birt.report.engine.content.IReportContent;
import org.eclipse.birt.report.engine.emitter.excel.ExcelXmlWriter.XMLWriterXLS;
import org.eclipse.birt.report.engine.emitter.excel.layout.ExcelContext;

/**
 * @author Administrator
 * 
 */
public class ExcelWriter implements IExcelWriter
{

	private ExcelXmlWriter writer, tempWriter;
	private final ExcelContext context;
	private String tempFilePath;
	private int sheetIndex = 1;

	/**
	 * @param out
	 * @param context
	 * @param isRtlSheet
	 * @param pageHeader
	 * @param pageFooter
	 * @param orientation
	 */
	public ExcelWriter( ExcelContext context )
	{
		this.context = context;
	}


	public void end( ) throws IOException
	{
		writer.end( );
	}

	public void endRow( )
	{
		writer.endRow( );
	}

	public void endSheet( double[] coordinates, String oritentation,
			int pageWidth, int pageHeight, float leftMargin, float rightMargin,
			float topMargin, float bottomMargin )
	{
		writer.endSheet( coordinates, oritentation, pageWidth, pageHeight,
				leftMargin, rightMargin, topMargin, bottomMargin );
	}

	public void outputData( String sheet, SheetData data, StyleEntry style, int column,
			int colSpan ) throws IOException
	{
		//TODO: ignored sheet temporarily
		outputData( data, style, column, colSpan );
	}

	public void outputData( SheetData data, StyleEntry style, int column,
			int colSpan ) throws IOException
	{
		writer.outputData( data, style, column, colSpan );
	}

	public void start( IReportContent report, Map styles,
	// TODO: style ranges.
			// List styleRanges,
			HashMap bookmarkList ) throws IOException
	{
		writer = new ExcelXmlWriter( context );
		writer.setSheetIndex( sheetIndex );
		// TODO: style ranges.
		// writer.start( report, styles, styleRanges, bookmarkList );
		writer.start( report, styles, bookmarkList );
		copyOutputData( );
	}

	private void copyOutputData( ) throws IOException
	{
		if ( tempWriter != null )
		{
			tempWriter.close( );
			BufferedReader reader = null;
			try
			{
				reader = new BufferedReader( new InputStreamReader(
						new FileInputStream( tempFilePath ), "UTF-8" ) );
				String line = reader.readLine( );
				XMLWriterXLS xlsWriter = writer.getWriter( );
				while ( line != null )
				{
					xlsWriter.literal( "\n" );
					xlsWriter.literal( line );
					line = reader.readLine( );
				}
			}
			finally
			{
				if ( reader != null )
				{
					reader.close( );
					reader = null;
					File file = new File( tempFilePath );
					if ( file.exists( ) && file.isFile( ) )
					{
						file.delete( );
					}
					tempFilePath = null;
					tempWriter = null;
				}
			}
		}
	}

	public void startRow( double rowHeight )
	{
		writer.startRow( rowHeight );
	}

	public void startSheet( String name ) throws IOException
	{
		if ( writer == null )
		{
			initializeWriterAsTempWriter( );
		}
		writer.startSheet( name );
		sheetIndex++;
	}

	public void startSheet( double[] coordinates, String pageHeader,
			String pageFooter, String name ) throws IOException
	{
		if ( writer == null )
		{
			initializeWriterAsTempWriter( );
		}
		writer.startSheet( coordinates, pageHeader, pageFooter, name );
		sheetIndex++;
	}

	/**
	 * @throws FileNotFoundException
	 * 
	 */
	private void initializeWriterAsTempWriter( ) throws FileNotFoundException
	{
		String tempFolder = context.getTempFileDir( );
		if ( !( tempFolder.endsWith( "/" ) || tempFolder.endsWith( "\\" ) ) )
		{
			tempFolder = tempFolder.concat( "/" );
		}
		tempFilePath = tempFolder + "birt_xls_"
				+ UUID.randomUUID( ).toString( );
		FileOutputStream out = new FileOutputStream( tempFilePath );
		tempWriter = new ExcelXmlWriter( out, context );
		writer = tempWriter;
	}

	public void endSheet( )
	{
		writer.endSheet( );
	}

	public void startRow( )
	{
		writer.startRow( );
	}

	public void outputData( int col, int row, int type, Object value )
	{
		writer.outputData( col, row, type, value );
	}

	public String defineName( String cells )
	{
		return writer.defineName( cells );
	}
}