Jump to content

Search the Community

Showing results for tags 'EXCEL'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • W3Schools
    • General
    • Suggestions
    • Critiques
  • HTML Forums
    • HTML/XHTML
    • CSS
  • Browser Scripting
    • JavaScript
    • VBScript
  • Server Scripting
    • Web Servers
    • Version Control
    • SQL
    • ASP
    • PHP
    • .NET
    • ColdFusion
    • Java/JSP/J2EE
    • CGI
  • XML Forums
    • XML
    • XSLT/XSL-FO
    • Schema
    • Web Services
  • Multimedia
    • Multimedia
    • FLASH

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


AIM


MSN


Website URL


ICQ


Yahoo


Jabber


Skype


Location


Interests


Languages

Found 17 results

  1. I am having a small issue translating my excel if statement into a CASE clause. Bellow I have posted my current SQL statement and the IF statement i am trying to fit in. I At the moment i have wrote it into the WHERE Clause but when i run it only returns the data which applies to the product description. Because of the way my where clause is set up it mean i only get half results where as i want it to show if column a does not match criteria then look for certain items in column b IF Statement is =IF(PD="AC","S",IF(PD="CS","S",IF(PD="CA","S",IF(**PT="SS","S"," ")**))) Curr
  2. ekioISpro

    Excel Export

    Hello, I am looking for some help please. So here's the deal --> I have to export CUSTOMIZED excel table filled by data from DataGrid. I just have to know how to edit cells (borders, background color, font, bold...etc) using this form of exporting. In an attachment you can take a look at my code (jut disregard the comments). Thank you
  3. I want to create a spreadsheet and then do a sort and display that sort as my html. Is there an easy way to do that?
  4. JamieY

    Help exporting xml

    Hello. Here is my problem that I really hope someone can help me solve. I work in the parts department at my company. On Monday, my boss is going to ask me to input a list of parts into a website that is going to take me about 4 hours to key in. It's about 400 or more lines of ten key that looks like this 1 123456-001 C14B23 5 123321-001-01 C1521 Repeat that with different numbers about 500 times. I found the website has an upload option so that I can import the parts. I know very little about XML. I got the company to send me an example upload file for the website. I have bee
  5. I need to check if value inserting in database while **import excel file** , if it has already value in database then it should get update. Below is producttab table value in database prdid | prdname 00A | prd1 00B | prd2 00C | prd3 00D | prd4 Below is EXCEL FILE data prdid | prdname 00A | prdnew 00B | prd2new 00E | prd8 00H | prd9 So if i upload above excel file then , 00A , 00B should get UPDATE IN producttab table as they are already present there... but 00E,00H should get insert below is what i have tried, value is
  6. john833

    XML to Excel

    Hello, I have a XML file with a lot of nested tags like <levelone> <content>abc</content) <contentb>def</contentb> . . . </levelone> And I want to convert each tag into a separate column with the corresponding value in Excel. Has anyone a hint where to start here? I tried opening it in Excel but it only displays the structure like in any text editor. Cheers, John
  7. Hi Guys! I have a xls file ex: 9015000000 I france I FRANCE I would like to automatically generates a txt file for each set of lines xls to have a line like this: <option value = "901500000001"> france - FRANCE </ option> Be done with xml or possible way Thanks!
  8. I have written a SQL Query for my Database at work in Excel so that I can automatically update it. Took me a while to figure out the date sections and getting it to return just the current date with the below code. WHERE f.FolioStatusId in (1, 7, 8, 9, 13) AND cast(f.made_on as date) >= cast(getdate() as date) What I'd like to do is to have a section in Excel where I can type the Dates that I need the data from and too. I know that I can insert a "?" in the query section to make a cell reference but cant figure out what code would need to go in the WHERE section to do that.
  9. Hi guys, here is what I have: an excel sheet (XLS, 4MB) with postal codes in the first column more data in the other columns here is what I need: looking for the postal code in the excel sheet get the information to this postal code from the other columns work with the other information (use them as variables) example: PC | A | B | C 1234 | 2.3 | 3.5 | 1.1 2345 | 3.3 | 3.3 | 7.8 ---> If I have the postal code 2345, I want to create the variables $a=3.3 ; $b=3.3 ; c=7.8 in PHP here i
  10. I've created a php file that gathers data from my SQL tables and creates a multi-sheet Excel workbook file in XML. I started this process by creating the file as I wanted it to appear using MS Excel 2010 and saved it as a XML file. I then wrote my PHP code to dynamically create the MS Excel XML file. In internet Explorer 11, when this is done, the file opens as a MS Excel file. My problem is that it doesn't work in Firefox (Version 31.0). In Firefox, it prints out on the screen as an unformatted XML file with the following message above the screen - "This XML file does not appear to have
  11. my focus is across a whole 3 years (156 weeks) of data, beginning January 1st 2011 (or nearest date) and ending December 31st 2013 (or nearest date) – so while we are looking at 3 years total, we will only end up with 52 weeks in our clean version of the data, labelled Week 1 to Week 52 (and not dates).there will be items in this list that launched before 1st Jan 2011, for which part of the launch year will show up in the period we’re focused on. In order that data percentiles (will be calculated at later stage) are not clouded by this, we also need to move any part year data from launches pre
  12. Hi, I am building some javascript calculators that must calculate according to an excel doc with formulas ; ie, (it must have same answers as excel sheet). I am fairly new at javascript but have gotten pretty far. The problem that im having is that the answers that my javscript calculators are producing arent exactly the same as the Excel formulas. (but very close) Example: Javascript Calculator- https://wzsdesign.com/WebTemplWP1/cal6.html Excel Formulas- If you take a look at the link with the javascript calculator and input the same numbers as the screen shot
  13. Hi all,Online registration form which allow users to fill in their details and send the data by submitting the form to my email using php.I need to create an online registration form and when the form is submitted, the data needs to go in to a spreadsheet in (MS EXCEL). Maybe a database I guess..The data should be able to be accessed at any time and read by a spreadsheet by someone in the office. Someone sent me this code $df = fopen("php://output", 'w'); fputcsv($df, array_keys(reset($array))); foreach ($_POSTas $row) { fputcsv($df, $row); } fclose($df); Can anyone help me as to
  14. Hi there!! Is there any way to import values of an Excel spreadsheet's fields using PHP? any help will be appreciated! Thanks in advance!! atar.
  15. I have this script which runs OK on an XP PC with Excel 2003 installed. When I try to run it on my XP PC with Excel 2010 I get an "Object doesn't support this action" 800A01BD error. Is this something to do with Excel 2010? Can the code be rewritten to get round this? +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Set objExcel = CreateObject("Excel.Application")objExcel.Visible = False dim partnumpartnum = Inputbox("Enter Part Number", "Search for Quotation by Part Number") Set objSearch = objExcel.FileSearchobjSearch.Lookin = "S:\Quotes"objSearch.SearchSubfolders = TRUEob
  16. jrppse7en

    VBScript

    Hey guys. Hope everyone here had a great 4th of July holiday! I am building an internal site that of course is only accessible via intranet. Its primary coding is very simple. Its HTML based with some Javascript and some VBScript. I will be honest. I am not an expert programmer by any means. So here is the issue. We have no access to the server logs as we do not admin the logs nor are we allowed to request them. We are basically borrowing the space. My management wants to have each page, when accessed or clicked on (either one) to log the hit to a csv file and a txt file saved on the server. I
  17. Hi all, Just a general question really. I have an MS Excel 2007 workbook that is used as input for estimates of cost and prices. The workbook will export the data from the workbook to an xml file for further use by other teams and interested parties. There are several xslt files that are used to manipulate the data from the workbook into different formats for other users, i.e. management just receive high level data, client receives another set of data. Some xslt files produce a HTML summary, some produce xml files for use in other workbooks. Currently the xslt files are held in the same fold
×
×
  • Create New...