TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
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
Forums
Monthly Leaders
Forum guidelines
Allan Andersen
NA
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#