Mixing
NPOI - Excel formula remove by formula evaluator method of NPOI when create new excel from template and...
Code:
using (var deststream = new FileStream(@"Template.xlsx", FileMode.Open, FileAccess.ReadWrite))
{
var workbook = new XSSFWorkbook(deststream);
workbook.GetSheet("Data").GetRow(1).GetCell(1).SetCellValue(20);
workbook.GetSheet("Data").GetRow(9).CreateCell(4).SetCellValue("Sahaj");
workbook.GetSheet("Data").GetRow(9).CreateCell(5).SetCellValue("anand");
//Not working below formula evaluator method 1
workbook.GetCreationHelper().CreateFormulaEvaluator().EvaluateAll();
//Not working below formula evaluator method 2
XSSFFormulaEvaluator.EvaluateAllFormulaCells(workbook);
using (FileStream file = new FileStream(@"Output.xlsx", FileMode.Create))
{
workbook.Write(file);
}
}
Template Excel File
From the above, I can able to create excel sheet from the template file but getting below calculation error when open output.xlsx.
Error in output file when open after generated from a template file.
Formula in Template file which is removed in output sheet after use of formula evaluator
I have used formula evaluator as same way explained in npoi documantion.
When I remove formula evaluator code from the method then I am able to see the formula in both excel Template and output.
So this is a bug of NPOI or something else ? please help me to solve it out.
Is there anyone here which know a proper way to use formula evaluator? I don't want to remove formula after calculation of it from the sheet.
c# excel npoi
asked Jan 1 at 11:06
ADMINADMIN
5151419
add a comment |
Code:
using (var deststream = new FileStream(@"Template.xlsx", FileMode.Open, FileAccess.ReadWrite))
{
var workbook = new XSSFWorkbook(deststream);
workbook.GetSheet("Data").GetRow(1).GetCell(1).SetCellValue(20);
workbook.GetSheet("Data").GetRow(9).CreateCell(4).SetCellValue("Sahaj");
workbook.GetSheet("Data").GetRow(9).CreateCell(5).SetCellValue("anand");
//Not working below formula evaluator method 1
workbook.GetCreationHelper().CreateFormulaEvaluator().EvaluateAll();
//Not working below formula evaluator method 2
XSSFFormulaEvaluator.EvaluateAllFormulaCells(workbook);
using (FileStream file = new FileStream(@"Output.xlsx", FileMode.Create))
{
workbook.Write(file);
}
}
Template Excel File
From the above, I can able to create excel sheet from the template file but getting below calculation error when open output.xlsx.
Error in output file when open after generated from a template file.
Formula in Template file which is removed in output sheet after use of formula evaluator
I have used formula evaluator as same way explained in npoi documantion.
When I remove formula evaluator code from the method then I am able to see the formula in both excel Template and output.
So this is a bug of NPOI or something else ? please help me to solve it out.
Is there anyone here which know a proper way to use formula evaluator? I don't want to remove formula after calculation of it from the sheet.
c# excel npoi
asked Jan 1 at 11:06
ADMINADMIN
5151419
add a comment |
Code:
using (var deststream = new FileStream(@"Template.xlsx", FileMode.Open, FileAccess.ReadWrite))
{
var workbook = new XSSFWorkbook(deststream);
workbook.GetSheet("Data").GetRow(1).GetCell(1).SetCellValue(20);
workbook.GetSheet("Data").GetRow(9).CreateCell(4).SetCellValue("Sahaj");
workbook.GetSheet("Data").GetRow(9).CreateCell(5).SetCellValue("anand");
//Not working below formula evaluator method 1
workbook.GetCreationHelper().CreateFormulaEvaluator().EvaluateAll();
//Not working below formula evaluator method 2
XSSFFormulaEvaluator.EvaluateAllFormulaCells(workbook);
using (FileStream file = new FileStream(@"Output.xlsx", FileMode.Create))
{
workbook.Write(file);
}
}
Template Excel File
From the above, I can able to create excel sheet from the template file but getting below calculation error when open output.xlsx.
Error in output file when open after generated from a template file.
Formula in Template file which is removed in output sheet after use of formula evaluator
I have used formula evaluator as same way explained in npoi documantion.
When I remove formula evaluator code from the method then I am able to see the formula in both excel Template and output.
So this is a bug of NPOI or something else ? please help me to solve it out.
Is there anyone here which know a proper way to use formula evaluator? I don't want to remove formula after calculation of it from the sheet.
c# excel npoi
asked Jan 1 at 11:06
ADMINADMIN
5151419
Code:
using (var deststream = new FileStream(@"Template.xlsx", FileMode.Open, FileAccess.ReadWrite))
{
var workbook = new XSSFWorkbook(deststream);
workbook.GetSheet("Data").GetRow(1).GetCell(1).SetCellValue(20);
workbook.GetSheet("Data").GetRow(9).CreateCell(4).SetCellValue("Sahaj");
workbook.GetSheet("Data").GetRow(9).CreateCell(5).SetCellValue("anand");
//Not working below formula evaluator method 1
workbook.GetCreationHelper().CreateFormulaEvaluator().EvaluateAll();
//Not working below formula evaluator method 2
XSSFFormulaEvaluator.EvaluateAllFormulaCells(workbook);
using (FileStream file = new FileStream(@"Output.xlsx", FileMode.Create))
{
workbook.Write(file);
}
}
Template Excel File
From the above, I can able to create excel sheet from the template file but getting below calculation error when open output.xlsx.
Error in output file when open after generated from a template file.
Formula in Template file which is removed in output sheet after use of formula evaluator
I have used formula evaluator as same way explained in npoi documantion.
When I remove formula evaluator code from the method then I am able to see the formula in both excel Template and output.
So this is a bug of NPOI or something else ? please help me to solve it out.
Is there anyone here which know a proper way to use formula evaluator? I don't want to remove formula after calculation of it from the sheet.
c# excel npoi
c# excel npoi
asked Jan 1 at 11:06
ADMINADMIN
5151419
asked Jan 1 at 11:06
ADMINADMIN
5151419
edited Jan 1 at 11:25
ADMIN
asked Jan 1 at 11:06
ADMINADMIN
5151419
asked Jan 1 at 11:06
ADMINADMIN
5151419
asked Jan 1 at 11:06
ADMINADMIN
5151419
5151419
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53994944%2fnpoi-excel-formula-remove-by-formula-evaluator-method-of-npoi-when-create-new%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53994944%2fnpoi-excel-formula-remove-by-formula-evaluator-method-of-npoi-when-create-new%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
