Two Questions

  • Thread starter Thread starter WStoreyII
  • Start date Start date
W

WStoreyII

Question 1
I am trying to create an app that will convert an excel sheet to a
predefined xml table. This i have undercontrol but as part of this app i
need to be able to view a list of sheets that are in a excel spreadsheet so
that the user may pick one once they have chosen a excel work book to load.
How is this done?

Question 2

I have seen several tutorials for how to set up a master details view for
databases. What I need though is more similiar to the subdatasheet view in
access where you click the plus sign and the dropdown shows right there.
When i create a relation in a datagrid it just shows the table that it is
related to and you have to clik it. How can i get it to work more like the
access view??

I want to you thank you guys in advance for any replies to this post. Also
i would just like to say that this is the most helpful , friendly and
educational newsgroup that i have ever been in. You guys allways answer my
questions and quickly to and you dont make me feel stupid. This is highly
appreciated. Have a great day!!!!

WStoreyII
 
WStorey:

Assuming you are using Com Interop to build the excel sheet, you can iterate
through the WorkSheets collection

For each worksheet in Worksheets
SomeControl.Items.Add(worksheet.Name)
Next

I don't use Access unfortunately so I can't help you there. However, if you
have your relations set up. you could have another form with a grid pop up
when the user clicks on the row o, sharing the same dataset and show only
the related records, or you have two grids or a listbox and a grid. Since I
don't know access though I'm probably more harm then help.
 
Cj

the page for q2 only shows how to make a master detail view there is a link
to remove the plus sign but at least i did not see a link for what i was
looking for. did i miss something?

wstoreyii
 
Ahh, I misinterpreted. Basically, the easy way to set it up is to use a
second grid and just use the positioning to appear so. So basically, you
have something in a datagrid, when that item is edited you switch your new
grid to visible and place it relative to the column your editing.

Hope that makes sense.

-CJ
 
Question 1

Has been answered well by others...

Question 2

I have seen several tutorials for how to set up a master details view for
databases. What I need though is more similiar to the subdatasheet view in
access where you click the plus sign and the dropdown shows right there.
When i create a relation in a datagrid it just shows the table that it is
related to and you have to clik it. How can i get it to work more like the
access view??
Click to expand...

Depending on what you want to show... I suppose you want to display Excel
files with their subsheets as children. If so, then I would definitly
recommend the good 'ol microsoft tree control from "Windows common
controls".

I want to you thank you guys in advance for any replies to this post. Also
i would just like to say that this is the most helpful , friendly and
educational newsgroup that i have ever been in. You guys allways answer my
questions and quickly to and you dont make me feel stupid. This is highly
appreciated. Have a great day!!!!
Click to expand...

You don't need to lick THAT hard to get answers around here :) LOL! Next
time write me a check :P

Alex.
 
Back
Top