Java

JeSpeak  Copyright (C) 2007  pjer at users dot sourceforge dot net
This program comes with ABSOLUTELY NO WARRANTY.
This is free software, and you are welcome to redistribute it
under certain conditions.
Exception in thread "main" java.lang.UnsatisfiedLinkError: no JeSpeak in java.library.path
	at java.lang.ClassLoader.loadLibrary(Unknown Source)
	at java.lang.Runtime.loadLibrary0(Unknown Source)
	at java.lang.System.loadLibrary(Unknown Source)
	at com.jespeak.JeSpeakNative.<clinit>(JeSpeakNative.java:25)
	at com.jespeak.JeSpeakImpl.<init>(JeSpeakImpl.java:26)
	at com.jespeak.JeSpeak.getInstance(JeSpeak.java:53)
	at com.jespeak.JeSpeak.main(JeSpeak.java:125)

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());