dont know if that will answer your questions but anyway http://poi.apache.org/hssf/limitations.html
so i would guess not can't you create your xl file based on an xl previously created, which would contain the macro? that may be a solution for you, if i understood your problem correctly cheers Lauren Riley wrote: > > > I am writing an Excel file that uses VLOOKUP, INDEX, and MATCH functions > to > look up information in other sheets, that I am also writing. As I come > into the spreadsheet, the values are shown as #VALUE. If I go up to the > top and view my function, all I have to do is hit enter at the end, and > then the correct value will display. I played with the > HSSFFormulaEvaluator some, but since those 3 functions aren't supported > yet, that didn't work either. So my last option was to create a macro > that > would just go hit enter on all those cells, hopefully showing my values > immediately. I'm not sure how to do this, however. Is it possible to > have > a macro run upon opening the spreadsheet created totally in HSSF? > > Thanks, Lauren > > __________________________________________ > The information contained in this message may be privileged and > confidential and protected from disclosure. If you are not the intended > recipient of this message, you are hereby notified that any dissemination, > distribution, or copying of this communication is strictly prohibited. If > you have received this communication in error, please notify us > immediately > by replying to the message, and please delete it from your computer. > -- View this message in context: http://www.nabble.com/File-Size-Problem%21-tp14604200p14673935.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
