Question about Microsoft Office Standard for PC

1 Answer

I want to save and retrieve some data from html page to excel. how to do this

Posted by on

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    President:

    An expert whose answer got voted for 500 times.

  • Master
  • 1,187 Answers

Remosofts,

  1. In a blank Excel sheet (or blank tab), click on the cell where you want the html page to begin placing data.
  2. From the top menu, select [Data] and choose [Get External Data] from the drop-down menu.
  3. Select [New web query] (view other options for future queries)
  4. A pop-up screen will have a few options, of course enter the html page location in the first box (Web address)
  5. You probably want to also select *The entire page (instead of only 'tables' default)
  6. Click [OK] and look at the data in your Excel sheet!
  7. You may want to adjust the options in future data retrievals.
Thanks for choosing FixYa!
-Gort.

Posted on Oct 11, 2010

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

5 Answers

How do i retrieve my device data from my other tablet


HI please fallow the instruction on this web site
https://www.recovery-android.com/recover-file-from-android.html

Jul 17, 2016 | Cell Phones

3 Answers

Excel workbook error


I came across this issue today. An update to the Office Compatibility Pack that was still on a computer caused the default PROGRAM for .docx and .xlsx files to be the Microsoft Open XML Converter program and make the "Default Programs" in Control Panel think that Excel and Word were actually the Microsoft Open XML Converter scholarship essay writing assistance program as well.UNINSTALLING the Office Compatibility Pack in Programs and Features and then a simple reboot fixed the issue.
Also:
1: Try to repair it manually when MS Excel does not automatically STARTS File recovery mode.
Click the Microsoft Office Button, and then click OPEN.
Now select the corrupted workbook that you want to open.
Click the arrow NEXT to the Open button, and then click Open and Repair.
Choose either Repair (to recover as much of the FILE data) or Extract data (to extract values and formula when repair process is not successful).
2: Open with Open Office: Try to open your Excel file in Open Office. It is an open-source Office suite that is able to open & SAVE Microsoft Excel files.
3: Save in HTML Format: Open your Excel file and save it in HTML format. By saving the workbook in HTML format, you may be able to filter out the corrupted elements.
4: Save in SYLK Format: Open your Excel file and save it in SYLK format. By saving the workbook in SYLK format, you may be able to filter out the corrupted elements.
5: Try 3rd party software like Excel Repair Toolbox
link: https://www.repairtoolbox.com/excelrepair.html

Jun 18, 2015 | Microsoft Office Excel 2007

5 Answers

Corrupt excel 2010 file


1 - Using "Open and repair"

Microsoft Excel has a built-in repair tool for corrupted files. To access it, go to File and Open. A menu will pop up in which you'll have to select the file you want to fix and then choose "Open and repair" from the dropdown menu. This will open a dialogue box in which you can pick between the repair option (which will recover as much information as possible) and the extract option (that will copy values and formulas). The two alternatives combined should work fine to save your work.

2 - Saving the file to a different format

If you can open the file but you can't modify it or save the changes, you should use this method. You'll have to save the file to a different format (such as SYLK or HTML) via the "Save as" menu. Once you've done this, you'll have to open the recently saved file and then save it once again (but this time, you'll have to choose the Excel Workbook as the format). By doing this, you'll be creating a fresh new file with all the data from the corrupted file.

3 - Opening the file in Microsoft Word

This option is only available for the people that have the Microsoft Excel converter installed on their PC (it can be downloaded from the Microsoft website). You simply have to open the corrupted Excel file with Word. However, you should know that this method only works for retrieving data (all the structures from the sheet will be gone, such as formulas and macros).

4 - Altering the Calculation option

If your file isn't opening at all you can try to adjust the calculation option. Simply open Excel in a blank workbook, go to the "Tools" menu and look for "Options". There you'll find the "Calculation" tab in which you'll have to look for the "Calculation" section and set it to "Manual". Click OK and then try to open the corrupted file once again.

5 - Linking the corrupted file

In this method, you'll have to link one cell of a blank worksheet to the corrupted workbook. Be sure to create the new worksheet in the same location as the corrupted file. Once you've done this go to the blank worksheet and enter the following in the A1 cell: <Filename>!A1. This will copy the data from the A1 cell of the corrupted file to the new sheet. In case it works, simply click "Edit" on the cell and select an area like the one covers the cell that contain data in the damaged file, and then click Paste. Then (and with the cells still selected) click Copy on the Edit menu.

Jan 23, 2013 | Western Digital Corporation WD ShareSpace...

2 Answers

Need to retrieve pictures from an old sanyo scp 3100


Hi there,your sanyo scp 3100 cell phone has a memory card on it.And your pictures are saved on the memory card.Therefore,you can retrieve pictures from memory card with data recovery software.I have succeed to retrieve pictures from SD card with Tenorshare data recovery.It can recover data after deeply scanning your memory card to look for lost data.
Anyway,download a trial version and scan your memory card for free to check out whether your pictures can be recovered.http://www.any-data-recovery.com/index.htm
BTW,you may need a card reader to connect your card with computer.
And this article will help.

How to Recover Files from Mobile Phone?
http://tenorsharedatarecovery.blogspot.com/2011/05/recover-deleted-files-from-memory-card.html

Jun 24, 2011 | Sanyo SCP-3100 Cellular Phone

1 Answer

Office 2003 Standard edition compatible w/ Small Business edition


Where were you saving the old Excel files to: c:\my documents for example. Is your new Excel saving or retrieving documents from the same location? If not, it will look like the old files are gone, when Excel is simply looking in the wrong place.

An installation won't wipe out data files--they're in two different locations. If you do a global wildcard search (*.xls) you will probably find them.

Dec 09, 2008 | Microsoft Office 2003 Small Business...

2 Answers

Windows excel file can't open


From Excel, try clicking on the 'down' arrow in the 'Open' button, then select, "Open and Repair," then select the file.

Nov 27, 2008 | Microsoft Office Access 2003 (077-02871)...

15 Answers

Export tally data to excel format


Select ASCII. Give output file name Eg:d:/exp Open the file using EXcel.Select Delimite  nexxt comma finish.Export is completed

Jan 02, 2008 | Tally T2245 Matrix Printer

3 Answers

Excel working


there are programs available in the net that can retrieve password of excel sheet..some are free and some are not. try searching the net.

Oct 26, 2007 | Microsoft Excel for PC

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

124 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2658 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18389 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...