|
Hi,
I am really having problems with excel/asp.net coding lately.
I am struggling to get the range from a worksheet in an excel workbook.
Basically the client uploads an excel spreadsheet to our server, and then we have an application that converts that code to a mdb/sql database, depending on what the client wants.
To get to the problem. Currently we tell the client what to call the specific range, with in a sheet (eg 'InvoiceData'), and from that we use a asp.net datasource(OLEDB) that connects to that sheet, retrieve the info we want, and then do whatever is requested with that info.
The problem now is, the client needs to call that range just what they want, and I need to access that range, to do as discussed above. There will only be one range per sheet.
Anyone who can help?
Thanks
|
|
|
|
|
Could you modify your upload form, giving the user an extra text box to enter the range name as well as upload the file?
|
|
|
|
|
Mike Ellison wrote: Could you modify your upload form, giving the user an extra text box to enter the range name as well as upload the file?
Hi Mike,
Yes, I will be able to do that, but not sure how I will be able to use this info, to select the range, or create a range? Any help on that?
|
|
|
|
|
Hi there. Wouldn't it be pretty much the same as what you're doing now? You have code now that expects a specific range name, yes? Why not just substitute a variable name for that part of the code, incorporating the name entered by the user?
|
|
|
|
|
HI,
Yes, you might have a point there. The only problem there might be, is that the use might not enter the range in correctly. I can cater for something like "sheet1$A1:K24", but I am concerned that once this work, there might be a possibility that more tables might be added per worksheet.... thus, using a range a client specifies, might not always be a safe option.
Also, some of the clients might not be that bright with excel, so I would like to cater for someone that just learned excel, and defining a range in excel, is much easier then telling the user to give me the range. Or what do you think?
|
|
|
|
|
Have you considered using a pre-made excel template? Something you would create and distribute to users, that could be locked (except for the range you want them to input)? If multiple tables may be necessary, you could include a button on the sheet to create a second sheet, also with cells locked (except for the input range again). Then your code could loop through the individual sheets and pull the range you're expecting to see...
We've used something like this for an internal survey application. We had the template survey.xls available for download by clicking an icon... users filled it out, then submitted it through an upload form. The template was predefinined to make it easier to work with on the server-end, and to limit the kinds of mistakes users could make.
Just a thought.
|
|
|
|
|
Problem,
To create a navigation menu that can be pulled into multiple pages, one that can change menu button imageurls (for up and down pressed buttons) and one that can access the page its pulled into or be given two values. (person type and person) Here what I have so far:
Create a control, either static or dynamic, something like below
<code<asp hyperlink id="GoPerson_View" runat="server">
then use the page name to determine if the button should be pressed down
Dim PageName As String = HttpContext.Current.Request.Path.ToString<br />
If PageName.Contains("Person_View") Then<br />
GoPerson_View.ImageUrl = "~/images/buttons/Person_View_Down.jpg"<br />
Else<br />
GoPerson_View.ImageUrl = "~/images/buttons/Person_View.jpg"<br />
End If
then i just need to assign the navigation properties
<br />
GoPerson_View.NavigateUrl = "~/Person_View.aspx?pid=" & PersonSelect.SelectedValue & "&fid=" & PersonTypeSelect.SelectedValue<br />
The issue being, without this code being on every page, and the controls too, i cannot get it to update properly if the personselect and persontypeselect values change (these are a list box and drop down list on each page).
this is becoming a major task to update each time a new page is being added. How do i get all this code into a central location.
-- modified at 14:03 Monday 21st August, 2006
|
|
|
|
|
i added an object data source to my form and i have written classes in my app_code.
when i configure the object data source there are no options to select for an object.
can u tell me wat the problem is please?
thank you
Nothing lasts but nothing is lost
|
|
|
|
|
Solly, this is a VS bug. Do you have alot of classes in your app_code folder?
I had the same problem not too long ago, and it drove me MAD. Try this: recreate (copy/paste) your form, data access class, and see if your object data source can find it.
Another way would be to do it in code view (not the designer), but it is a real pain to not do things like this visually.
Nila
|
|
|
|
|
There are a couple of things that you may check:
+ The class is marked as public.
+ By default the Configure DataSource dialog box only displays the objects marked with the attribute DataObjectAttribute . If your objects don't have this attribute then you need to uncheck the checkbox "Show only data components"
|
|
|
|
|
Hello,
I am trying to build an ASP.NET webform that uses the en-GB culture. This screen needs to display dates MM-dd-yy and currencies in EUR using the € or € symbol.
1) does the Euro symbol come before or after the currency amount? Is there a space between them?
2) I set the culture page directive in the ASP.NET page to en-GB. This makes the currencies in my datagrid display in the GBP, but I need currencies to show in the euro. How is this overridden?
<br />
' page directive...<br />
Culture="en-GB"<br />
. . .<br />
' datagrid<br />
<%# DataBinder.Eval(Container.DataItem, "UNIT_PRICE", "{0:C}") %><br />
[Note: This is .NET 1.1, VS. NET 2003]
Thanks for the tips,
-- modified at 13:49 Monday 21st August, 2006
Josh Blair
http://joshblair.blogspot.com/
|
|
|
|
|
Hi there,
According to the official recommedation, the currency symbol comes before the money amount with no space in between, however it may vary from nations to nations. You can read more about this from the links:
http://ec.europa.eu/economy_finance/euro/our_currency_en.htm[^]
http://en.wikipedia.org/wiki/Euro#The_currency_sign_.E2.82.AC[^]
And the default currency symbol of the en-GB cutlure is the £, not the €, so to use the euro symbol, you'll have a couple of options to do:
+ Change the currency symbol in the Regional setting in the control panel.
+ Change the currency symbol at runtime using the CurrencySymbol property of the NumberFormatInfo object.
+ Hard code the currency symbol when you do the number formatting.
|
|
|
|
|
Thanks for the tips.
Josh Blair
http://joshblair.blogspot.com/
|
|
|
|
|
i want to show calender when user click in textbox
omi
|
|
|
|
|
omi98 wrote: i want to show calender when user click in textbox
And what specifically[^] are you having trouble with?
|
|
|
|
|
Create a web form and name it 'PopUpCalendar.aspx'.
add a calendar control onto it.
On your calling form add a textbox with property as below:
<A onclick="window.open('PopUpCalendar.aspx textbox=txtStartDate','cal','width=220,height=200,left=450,top=150')"
tabIndex="-1" href="javascript:;"> <asp:TextBox id="Textbox2" style="Z-INDEX: 103; LEFT: 8px; POSITION: absolute; TOP: 8px" runat="server"></asp:TextBox></a>
postmaster
http://www.programmingknowledge.com
-- modified at 22:11 Monday 21st August, 2006
|
|
|
|
|
Hi:
I know in ASP.NET 2.0 that there is a new handler called WebResource.axd that enables control and page developers to download resources that are embedded in an assembly by making use of the Page.GetWebResourceUrl method.
Can anyone tell me how this can be accomplished in ASP.NET 1.1? Is there an alternative ?
I would really appreciate any DETAILED suggestions or references to articles...
Thanks...
|
|
|
|
|
|
can anyone explain to me how I can do the following and how it works.
I have a listbox on a page. I also have a control (menu.ascx) that changes a querystring variable on the navigateurl property according to the selected value of that list box. On the pages first load this all works fine, however, when you change the value of the list box it does not update the button. I presume this is something to do with th order of events e.t.c but surely there is a good way to access parent controls values. This seems like something lots of people would want to do.
Example:
Lisbox: value is 1 name is Bob
Mybutton1.NavigateURL = "~/myfiles/showperson.aspx?id=" & The passed variable here
|
|
|
|
|
You can access controls in the parent page.
Button Mybutton1 = (Button) this.Parent.FindControl("Mybutton1");
how vital enterprise application are for proactive organizations leveraging collective synergy to think outside the box and formulate their key objectives into a win-win game plan with a quality-driven approach that focuses on empowering key players to drive-up their core competencies and increase expectations with an all-around initiative to drive up the bottom-line. But of course, that's all a "high level" overview of things
--thedailywtf 3/21/06
|
|
|
|
|
hi,
i have a dropdown list which should be databound to a database table. Thats is fine, but i want to have first 2 entries of the list to be static and the rest from database table...like
list values : choose one....
All
the rest from database table.
to achieve this what to do in the asp.net page and in the c# page.
thanks
|
|
|
|
|
You can add the values to sql statement using a union statment. Or after the databind insert a listitem object into the dropdownlist.
how vital enterprise application are for proactive organizations leveraging collective synergy to think outside the box and formulate their key objectives into a win-win game plan with a quality-driven approach that focuses on empowering key players to drive-up their core competencies and increase expectations with an all-around initiative to drive up the bottom-line. But of course, that's all a "high level" overview of things
--thedailywtf 3/21/06
|
|
|
|
|
|
Set "AppendDataBoundItems" property of DropDownList to "true" and all databound items will be added after items you've added manually.
e.g.
<asp:DropDownList id="SomeDropDownList" AppendDataBoundItems="true" runat="server">
<asp:ListItem>Please choose one</asp:ListItem>
<asp:ListItem>_________________</asp:ListItem>
</asp:DropDownList>
|
|
|
|
|
sidonath,i think asp.net1.1 dropdownlist control does not have the AppendDataBoundItems property.
|
|
|
|