Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
2
Reply
How to run through excelfile and group rows
Allan Andersen
Jan 27 2017 8:54 AM
206
Reply
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.
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
2
)
Next Recommended Forum
Page Panel Content Convert to PDF,but getting empty pdf
Inserting data from string list into mongodb c#