using jxl to write formula in excel
-
Hello, I want to write a formula in excel through java but when I do the following a formula is displayed in the cell without displaying the results.The error with the formula is also seen.'A value used in the formula is of wrong data type' but the above error disappears if I reenter the same formula for the same data.I am using the following code to do with jxl libraries.
StringBuffer buf = new StringBuffer();
buf.append("MDETERM(A1:D4)");
Formula f = new Formula(0, 11, buf.toString());Pritha
-
Hello, I want to write a formula in excel through java but when I do the following a formula is displayed in the cell without displaying the results.The error with the formula is also seen.'A value used in the formula is of wrong data type' but the above error disappears if I reenter the same formula for the same data.I am using the following code to do with jxl libraries.
StringBuffer buf = new StringBuffer();
buf.append("MDETERM(A1:D4)");
Formula f = new Formula(0, 11, buf.toString());Pritha
Me thinks the formula is wrong, try:
buf.append("=MDETERM(A1:D4)");
Panic, Chaos, Destruction. My work here is done. Drink. Get drunk. Fall over - P O'H OK, I will win to day or my name isn't Ethel Crudacre! - DD Ethel Crudacre I cannot live by bread alone. Bacon and ketchup are needed as well. - Trollslayer Have a bit more patience with newbies. Of course some of them act dumb - they're often *students*, for heaven's sake - Terry Pratchett
-
Me thinks the formula is wrong, try:
buf.append("=MDETERM(A1:D4)");
Panic, Chaos, Destruction. My work here is done. Drink. Get drunk. Fall over - P O'H OK, I will win to day or my name isn't Ethel Crudacre! - DD Ethel Crudacre I cannot live by bread alone. Bacon and ketchup are needed as well. - Trollslayer Have a bit more patience with newbies. Of course some of them act dumb - they're often *students*, for heaven's sake - Terry Pratchett