Import an existing EXCLE-File

[Kevin]

Using ASP.NET MVC 4 without EJ2

.:: Existing EXCLE-File has ::.
- 3 Sheets
- different tables, which can be accessed by its (custom)name

.:: Read the values by its table name, which is inside Sheet 2 ::.

That table(4x10) has:

- heading(4x1)
- values(4x8)
- Total row for every heading(4x1)
- and a name which I can access unique(I want to give it in the GUI)

=> 3 of them.

At the end, I need:
a) - dataset's with every row - based on its heading - with its content(without the total, or at least extra)
b) - every row, based on its heading-name(without the total, or at least extra)

Thanks

[Prakash Kumar D]

Hi Kevin, 

 

 

 

Thank you for contacting Syncfusion support. 

 

 

We have prepared the sample as per your requirement.  Kindly download the sample from the following link 

 

 

Link : http://www.syncfusion.com/downloads/support/forum/139013/ze/CreateSpreadsheet-226662505 

 

 

Regards, 

Prakash Kumar 

[Kevin]

Hi,

can I have the same example for pivot-tables ?!

Thanks

[Prakash Kumar D]

Hi Kevin, 

 

Thank you for updating us. 

 

We have prepared sample as per your requirement. Kindly download the sample from the following link  

http://www.syncfusion.com/downloads/support/forum/139013/ze/CreateSpreadsheet2129672717  

 

Please let us know if you need any further assistance. 

 

Regards, 

Prakash Kumar 

[Kevin]

Hi ; I dont habe the "Text" property.

.Fields[field].Items[l].Text

=> "'IPivotFieldItem' does not contain a definition for 'Text' and no extension method 'Text' accepting a first argument of type 'IPivotFieldItem' could be found"

Using Syncfusion: 14.2450.0.26

[Kevin]

By the way I need the headings,  of that pivot-result-table

not the fields name .Fields[l].Name.

please change the example

[Prakash Kumar D]

Hi Kevin,  

 Thank you for updating us.  

 We have prepared sample as per your requirement. Kindly download the sample from the following link   

http://www.syncfusion.com/downloads/support/forum/139013/ze/CreateSpreadsheet-110739438 

 Please let us know if you need any further assistance.  

 Regards,  

Prakash Kumar