Java

jonig19 wrote:

I need to create a method that reads in bytes until it reaches a nullterminator using FileInputStream. Can someone point me in the right direction?

ExtendedFormatRecord r =new ExtendedFormatRecord();
r.setShrinkToFit(true);

import java.io.*; 
import jxl.*; 
import jxl.write.*;

public class ShrinkToFitExample 
{
	public static void main(String[] args) throws Exception
	{
		WritableWorkbook workbook = Workbook.createWorkbook(new File("output.xls"));
		WritableSheet sheet = workbook.createSheet("First Sheet", 0);
		WritableCellFormat arial10format = new WritableCellFormat(); 
		arial10format.setShrinkToFit(true);
		Label label2 = new Label(1,0, "demo Text", arial10format); 
		sheet.addCell(label2);
		workbook.write(); 
		workbook.close();
	}
}

public bool ShrinkToFit
{
    get
    {
        return format.ShrinkToFit;
    }
    set
    {
        // Not sure if this line is necessary
        format.IsIndentNotParentAlignment = (true);
        format.ShrinkToFit = (value);
        /* Not sure of the consequences of changing the XFType,
         * but shrink to fit only works on XF_CELL */
        format.XFType = ExtendedFormatRecord.XF_CELL;
    }
}

// In C#
HSSFCellStyle cellstyle1 = hssfworkbook.CreateCellStyle();
cellstyle1.ShrinkToFit = true;

// In Java
HSSFCellStyle style = workbook.createCellStyle();
style.setShrinkToFit(true);

// In C#
public static void SetLeftHeaderPicture(String Workbook,String Sheet,String Image)
        {
            Application excelApp = new ApplicationClass();
            excelApp.Visible = false;
            Workbook newWorkbook = excelApp.Workbooks.Add(XlWBATemplate.xlWBATWorksheet);
            string workbookPath = Workbook;
            Workbook excelWorkbook = excelApp.Workbooks.Open(workbookPath, 0, false, 5, "", "", false, XlPlatform.xlWindows, "", true, false, 0, true, false, false);
            Sheets excelSheets = excelWorkbook.Worksheets;
            string currentSheet = Sheet;
            Worksheet excelWorksheet = (Worksheet)excelSheets.get_Item(currentSheet);
            excelWorksheet = (Worksheet)excelWorkbook.ActiveSheet;
            excelWorksheet.PageSetup.LeftHeaderPicture.Filename = Path.GetFullPath(Image);
            excelWorksheet.PageSetup.LeftHeader = "&G";
            excelWorksheet.PageSetup.LeftHeaderPicture.Height = 100;
            excelWorksheet.PageSetup.LeftHeaderPicture.Width = 150;
            excelWorkbook.Save();
        }

// In C#
excelWorksheet.PageSetup.RightHeaderPicture.Filename = Path.GetFullPath(Image);
            excelWorksheet.PageSetup.RightHeader = "&G";
            excelWorksheet.PageSetup.RightHeaderPicture.Height = 100;
            excelWorksheet.PageSetup.RightHeaderPicture.Width = 150;

// In Java
HSSFHeader header = sheet.getHeader();// or Footer
// Do what ever you want here but do not set the header to the place you want the image to be and make sure you write the excel file at this stage
// The last line for example in the Main method must be:
HeaderFooter.HFPicture("CH", "C:\\Excel.xls", "Sheet0", "c:\\image.jpg");
/*
1. Where CH means CenterHeader
2. Where C:\\Excel.xls is the path of the output excel
3. Where Sheet0 is the sheet
4. Where c:\\image.jpg is the image you want to set
*/

// Add this in Main method in C# class
StreamReader objReader = new StreamReader("HFPicture.txt");
            string sLine = "";
            ArrayList arrText = new ArrayList();

            while (sLine != null)
            {
                sLine = objReader.ReadLine();
                if (sLine != null)
                    arrText.Add(sLine);
            }
            objReader.Close();

            if (arrText[0].ToString() == "LH")
                SetLeftHeaderPicture(arrText[1].ToString(), arrText[2].ToString(), arrText[3].ToString());
            if (arrText[0].ToString() == "CH")
                SetCenterHeaderPicture(arrText[1].ToString(), arrText[2].ToString(), arrText[3].ToString());
            if (arrText[0].ToString() == "RH")
                SetRightHeaderPicture(arrText[1].ToString(), arrText[2].ToString(), arrText[3].ToString());
            if (arrText[0].ToString() == "LF")
                SetLeftFooterPicture(arrText[1].ToString(), arrText[2].ToString(), arrText[3].ToString());
            if (arrText[0].ToString() == "CF")
                SetCenterFooterPicture(arrText[1].ToString(), arrText[2].ToString(), arrText[3].ToString());
            if (arrText[0].ToString() == "RF")
                SetRightFooterPicture(arrText[1].ToString(), arrText[2].ToString(), arrText[3].ToString());

// 04printing.php is under Tests in the PHPExcel folder. Paste the code below. 
// The name of the Excel file is Test.xlsx so make sure it is the name of your Excel file.
// http://localhost/xampp/phpexcel-28925/Tests/04printing.php

<?php

/** Error reporting */
error_reporting(E_ALL);

/** PHPExcel */
require_once '../Classes/PHPExcel.php';

/** PHPExcel_IOFactory */
require_once '../Classes/PHPExcel/IOFactory.php';

// Create new PHPExcel object
echo date('H:i:s') . " Create new PHPExcel object\n";
$objPHPExcel = PHPExcel_IOFactory::load("Test.xlsx");

// Set header and footer. When no different headers for odd/even are used, odd header is assumed.
echo date('H:i:s') . " Set header/footer\n";
$objPHPExcel->getActiveSheet()->getHeaderFooter()->setOddHeader('&L&G&C&HPlease treat this document as confidential!');
$objPHPExcel->getActiveSheet()->getHeaderFooter()->setOddFooter('&L&G&C&HPlease treat this document as confidential!');

// Add a drawing to the header
echo date('H:i:s') . " Add a drawing to the header\n";
$objDrawing = new PHPExcel_Worksheet_HeaderFooterDrawing();
$objDrawing->setName('PHPExcel logo');
$objDrawing->setPath('./images/phpexcel_logo.gif');
$objDrawing->setHeight(36);
$objPHPExcel->getActiveSheet()->getHeaderFooter()->addImage($objDrawing, PHPExcel_Worksheet_HeaderFooter::IMAGE_FOOTER_LEFT);

// Set active sheet index to the first sheet, so Excel opens this as the first sheet
$objPHPExcel->setActiveSheetIndex(0);

		
// Save Excel 2007 file
echo date('H:i:s') . " Write to Excel2007 format\n";
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save('Test.xlsx');

// using System.IO;
StreamWriter sw = new StreamWriter("HFPicture.txt"); 
            sw.WriteLine("&L&G&C&HPlease treat this document as confidential!");// HeaderFooter formatter i.e. Text,Image, or both
            sw.WriteLine("C:\\image1.gif");// The Image path
            sw.WriteLine("Test.xlsx");// The Excel File Name
            sw.WriteLine("Header");// Header or Footer only (sensitive)
            sw.WriteLine("IMAGE_HEADER_LEFT"); // where you want it IMAGE_ is a must
            sw.WriteLine("C:\\"); // The Excel File Path which is the path of the File Name above
            sw.Close();
            System.Diagnostics .Process .Start ("HFPicturePHPExcel.exe");

// import java.oi.*;
PrintWriter out = new PrintWriter(new File("HFPicture.txt"));
	out.println("&L&G&C&HPlease treat this document as confidential!");// HeaderFooter formatter i.e. Text,Image, or both
        out.println("C:\\image1.gif");// The Image path
        out.println("Test.xlsx");// The Excel File Name
        out.println("Header");// Header or Footer only (sensitive)
        out.println("IMAGE_HEADER_LEFT"); // where you want it IMAGE_ is a must
        out.println("C:\\"); //The Excel File Path which is the path of the File Name above
        out.close();
	Runtime.getRuntime().exec("HFPicturePHPExcel.exe");

// set the core for thread1
SetThreadAffinityMask(GetCurrentThread(), new IntPtr(2));

// Here the block the thread execute.