ExpertXLS Excel Library for .NET - Support

by Outside Software - Product Type: Component / .NET Class / .NET WPF / 100% Managed Code

Support Forum

ExpertXLS Excel Library for .NET pivot pkoelbl [OH, USA] 29-Mar-2011 15:23:40

Is it possible to refresh a pivot tables data using ExpertXLS? If so how?
Reply

Subtotals? Matt [UT, USA] 23-Feb-2011 19:08:52

I am working on sorting a .xls file of inbound and outbound calls with C#. They are all on one worksheet called detail and then I separate them into two other worksheets within the same workbook. What I'm looking for is the ability to do subtotals on those inbound and outbound worksheets to give the number of calls for each specific number. Is there a method I can call to add subtotals? If so how is that done?

Thank you in advance!
Matt
Reply

RE: Subtotals? support@componentsource.com 25-Feb-2011 16:20:10

Hi Matt,

Thank you for submitting your query in the ExpertXLS Excel Library for .NET forum here at ComponentSource.

I run your query with the authors of the product and they sent me this information for you:
===
You just need to write a formula that will total those rows into a cell of your choice.
===

Should you require any assistance then, please do not hesitate to contact us on support@componentsource.com

I hope it helps.

Regards,

Enrique Perez
ComponentSource Support
Reply

RE: RE: Subtotals? Matt [UT, USA] 28-Feb-2011 23:55:16

I'm to this point in the code where I can add in the needed formula but I need it to be dynamic. In the developer's guide it shows that I can use *.Formula = "=COUNT(:)"; But I don't know the exact cells because they change in each iteration. Is there a way that I can put variables into the row and column slots of this formula call?
Reply

ExpertXLS Excel Library for .NET jacqui.booth [United Kingdom] 12-Mar-2010 11:31:15

Does the product allow a spreadsheet to be saved in a format suitable for viewing in a web browser where the client doesn't have Excel installed e.g. HTML or PDF?
Reply

RE: ExpertXLS Excel Library for .NET develop.site [Korea, Republic Of] 22-Apr-2010 09:28:35

안녕하세요.
질문이 있어 이렇게 포럼에 글을 올립니다^^

트라이얼을 받아 샘플, API Reference 등을 보고 테스트를 여러가지로 해봤는데요.

이미지를 셀 안에 맞게 넣을 수 있도록 할 수는 없는 것 같던데 맞나요?
left, right
top, bottom
각각의 4좌표가 있다면 좌표에 맞게 이미지를 늘려서 표현하고 싶은 것입니다.

scale의 with, height을 줄수는 있지만
그것은 직관적이지 않을 뿐만 아니라 좀 불편한 방법인 것 같습니다.

답변 부탁드립니다.
Reply

ExpertXLS Excel Library for .NET jf.pedrazzani [France] 05-Feb-2010 18:14:18

Hi,
i have a value of string like "00123456789" and i'm unable to preserve the first "00" when i uses LoadDataView to bind data in a WorkSheet.
the datasource field are Sql varchar but the first "00" alway hide in excel.
i have try with oSheet[iStart, iCol].Style.Number.NumberFormatString = "@";
and
oSheet[iStart, iCol].Style.Number.NumberFormatString = "0";

But nothing change..
Any idea?

Cordialy
jf
Reply

RE: ExpertXLS Excel Library for .NET support@componentsource.com 08-Feb-2010 10:08:36

Hi,

No valid numbers start with 0. You should try to format the cell as text/string.
Reply

RE: RE: ExpertXLS Excel Library for .NET pkoelbl [OH, USA] 25-Feb-2011 21:50:47

How do you format it as text/string when the worksheet is being loaded from a dataset?
Reply

"Invalid number of formats." spadhye [USA] 02-Sep-2009 14:53:46

What does the error message "Invalid number of formats." mean? I am trying to se the top, botto, left and right borders of each cell in a range of cells. It does not work whether I do it row by row, or for the entire range at once.
Reply

RE: "Invalid number of formats." tbarbedo [USA] 09-Sep-2009 20:50:38

having the same exact problem...someone please help!
Reply

RE: "Invalid number of formats." tbarbedo [USA] 09-Sep-2009 21:39:04

Hey my friend I found a solution for this....

1. define a style

ExcelCellStyle mystyle = workbook.Styles.AddStyle("mystyle");
mystyle.Borders[ExcelCellBorderIndex.Bottom].LineStyle = ExcelCellLineStyle.Thin;

2. set style of a range to that style

ExcelRange range = worksheet["A1:A2"];
range.Style = mystyle;

this will put the borders there with no errors...
Reply