EDN Admin
Well-known member
Hi,
I am automating our excel report using .net. I am not a programmer and hence I have little/no knowledge of VB .net. Below are few questions if anyone can help me out then it will be great.
1. I want to auto filter a column from an excel (say column C with the criterion as "Active"), and the values of Column A are selected in a combobox. Once the user selects a value in the first combobox, the items in the second combobox are from column B, corresponding to lookup of column A. So below, if Xyz is selected in the first combobox, then the second combobox value should be T and likewise.
Example -
A B
Xyz T
ABC U
2. My form also has a month date picker with multi selection, and all the selections are saved in an excel. In case more than one date is selected , the other selections in the form needs to be repeated in excel. Also how can i ensure that an excel (shared one with standard name) is created incase it doesnt exist?
TIA
View the full article
I am automating our excel report using .net. I am not a programmer and hence I have little/no knowledge of VB .net. Below are few questions if anyone can help me out then it will be great.
1. I want to auto filter a column from an excel (say column C with the criterion as "Active"), and the values of Column A are selected in a combobox. Once the user selects a value in the first combobox, the items in the second combobox are from column B, corresponding to lookup of column A. So below, if Xyz is selected in the first combobox, then the second combobox value should be T and likewise.
Example -
A B
Xyz T
ABC U
2. My form also has a month date picker with multi selection, and all the selections are saved in an excel. In case more than one date is selected , the other selections in the form needs to be repeated in excel. Also how can i ensure that an excel (shared one with standard name) is created incase it doesnt exist?
TIA
View the full article