E-Office
Tampilkan postingan dengan label MS. Office Excel. Tampilkan semua postingan
Tampilkan postingan dengan label MS. Office Excel. Tampilkan semua postingan

File formats that are not supported in Excel

If the file format that you want to use is not supported in Excel, you can try the following:
  1. Search the World Wide Web (WWW) for a company that makes file format converters for file formats that are not supported in Excel.
  2. Save to a file format that another program supports. For example, you may want to import your spreadsheet into another program that does not support the Excel file format. But the other program may be able to import another supported file format, such as an XML spreadsheet or a text file format. In this case, you can save your workbook to the XML spreadsheet format, and then from the other program, import the XML file.
>

[+/-] as complete...“File formats that are not supported in Excel”  »»

Clipboard formats

You can paste data from the Microsoft Office Clipboard into Excel by using the Paste or Paste Special command (Home tab, Clipboard group, Paste button) if the Office Clipboard data is in one of the following formats.

Picture (.wmf or .emf) : Pictures in Windows Metafile Format (WMF) or Windows Enhanced Metafile Format (EMF).
Note : If you copy a Windows metafile picture from another program, Excel pastes the picture as an enhanced metafile.

Bitmap (.bmp) : Pictures stored in Bitmap format (BMP).
Microsoft Excel file formats (.xls) : Binary file formats for Excel versions 5.0/95 (BIFF5), Excel 97-2003 (BIFF8), and Office Excel 2007 (BIFF12).
SYLK (.slk) : Symbolic Link Format.
DIF (.dif) Data Interchange Format.
Text (tab-delimited) (.txt) Tab-separated text format.
CSV (Comma-delimited) (.csv) Comma-separated values format.
Formatted text (Space-delimited) (.rtf): Rich Text Format (RTF). Only from Excel.
Embedded object (.gif, .jpg, .doc, .xls, or .bmp) : Microsoft Excel objects, objects from properly registered programs that support OLE (OLE: A program-integration technology that you can use to share information between programs. All Office programs support OLE, so you can share information through linked and embedded objects.) 2.0 (OwnerLink (OwnerLink: An OLE data format that describes an embedded object, identifying the class, document name, and name of an object. Each of these data items is a null-terminated string.)), and Picture or another presentation format.
Linked object (.gif, .jpg, .doc, .xls, or .bmp) : OwnerLink, ObjectLink (ObjectLink: An OLE data format that describes a linked object, identifying the class, document name, and name of an object. Each of these data items is a null-terminated string.), Link, Picture, or other format.
Office drawing object (.emf) : Office drawing object format or Picture (Windows enhanced metafile format, EMF).
Text (.txt) : Display Text, OEM Text.
HTML (.htm) : Hypertext Markup Language.

[+/-] as complete...“Clipboard formats”  »»

Other formats

Quattro Pro 5.0 (Win) (.wb1): Quattro Pro version 5.0 for Windows. You can open Quattro Pro files in Excel by using a converter. You cannot save an Excel file to Quattro Pro format.
Quattro Pro 7.0 (Win) (.wb3) :Quattro Pro version 7.0 for Windows. You can open Quattro Pro files in Excel by using a converter. You cannot save an Excel file to Quattro Pro format.

[+/-] as complete...“Other formats”  »»

Text formats

Formatted Text (Space-delimited) (.prn) : Lotus space-delimited format. Saves only the active sheet.
Text (Tab-delimited) (.txt) : Saves a workbook as a tab-delimited text file for use on another Microsoft Windows operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves only the active sheet.
Text (Macintosh) (.txt) : Saves a workbook as a tab-delimited text file for use on the Macintosh operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves only the active sheet.
Text (MS-DOS) (.txt) : Saves a workbook as a tab-delimited text file for use on the MS-DOS operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves only the active sheet.
Unicode Text (.txt) : Saves a workbook as Unicode text, a character encoding standard that was developed by the Unicode Consortium.
CSV (comma delimited) (.csv) : Saves a workbook as a comma-delimited text file for use on another Windows operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves only the active sheet.
CSV (Macintosh) (.csv) : Saves a workbook as a comma-delimited text file for use on the Macintosh operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves only the active sheet.
CSV (MS-DOS) (.csv) : Saves a workbook as a comma-delimited text file for use on the MS-DOS operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves only the active sheet.
DIF (.dif) : Data Interchange Format. Saves only the active sheet.
SYLK (.slk) : Symbolic Link Format. Saves only the active sheet.

[+/-] as complete...“Text formats”  »»

Excel formats

Excel Workbook (xlsx) : The default Office Excel 2007 XML-based file format. Cannot store VBA macro code or Microsoft Office Excel 4.0 macro sheets (.xlm).
Excel Workbook (code) (xlsm) : The Office Excel 2007 XML-based and macro-enabled file format. Stores VBA macro code or Excel 4.0 macro sheets (.xlm).
Excel Binary Workbook (xlsb) : The Office Excel 2007 Binary file format (BIFF12).
Template .xltx The default Office Excel 2007 file format for an Excel template. Cannot store VBA macro code or Excel 4.0 macro sheets (.xlm).
Template (code) (xltxm) : The Office Excel 2007 macro-enabled file format for an Excel template. Stores VBA macro code or Excel 4.0 macro sheets (.xlm).
Excel 97- Excel 2003 Workbook (xls): The Excel 97 - Excel 2003 Binary file format (BIFF8).
Excel 97- Excel 2003 Template (xlt):The Excel 97 - Excel 2003 Binary file format (BIFF8) for an Excel template.
Microsoft Excel 5.0/95 Workbook (xls) : The Excel 5.0/95 Binary file format (BIFF5).
XML Spreadsheet 2003 (xml) : XML Spreadsheet 2003 file format (XMLSS).
XML Data (xml) : XML Data format.
Excel Add-In (xlam) : The Office Excel 2007 XML-based and macro-enabled Add-In, a supplemental program that is designed to run additional code. Supports the use of VBA projects and Excel 4.0 macro sheets (.xlm).

[+/-] as complete...“Excel formats”  »»

File formats that are supported in Excel

You can save a Microsoft Office Excel 2007 file in another file format by clicking Microsoft Office Button , and then Save As. The file formats that are available in the Save As dialog box vary, depending on what type of sheet is active (a worksheet, chart sheet, or other type of sheet).
You can open a file that was created in another file format (in an earlier version of Microsoft Office Excel or in another program) by clicking Microsoft Office Button , and then Open. You will be prompted to save it to an Office Excel 2007 format, unless you open a workbook that is shared. For files that were created in an earlier version of Excel, you have the option to keep the original format.

[+/-] as complete...“File formats that are supported in Excel”  »»

<