Want to build the ChatGPT based Apps? Start here
Become a member
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
C# Corner Home
Technologies
Monthly Leaders
ASK A QUESTION
Forum guidelines
Allan Andersen
0
12
0
How to run through excelfile and group rows
Jan 27 2017 8:54 AM
Hi
I have an excel file looking something like this:
Company
Year
Month
Day
Count
Comp1
2016
1
1
2
Comp1
2016
1
3
1
Comp1
2016
1
4
3
Comp1
2016
2
1
4
Comp1
10
Comp2
2016
1
1
1
Comp2
2016
1
2
3
Comp2
2016
1
3
5
Comp2
2016
2
2
2
Comp2
2016
3
3
3
Comp2
2016
3
4
1
Comp2
15
Comp3
2016
1
1
2
Comp3
2016
1
2
3
Comp3
5
What i want to do is run through this sheet and group rows according to Company so i get that little "+" or "-" button beside the group.
The number of rows for each company will not be the same every time this excel file is created, so i can't just say "make cell A1 to A5 a group". i have to do this dynamically.
I have tried to google this but i can't find the answer. The problem could be that i simply just don't know how to write this problem in a search string for google.
Is this at all possible (i think it is) and how do i do this?
I hope some of you in here can help me.
Reply
Answers (
2
)
Page Panel Content Convert to PDF,but getting empty pdf
Inserting data from string list into mongodb c#