| | Feedback | Embed Excel | Symbols and bullet points | | ||
The example below shows how ASCII character codes can be converted and used in Excel. The functions can be used with random numbers to generate codes of characters.
| Function | Purpose | Example | Result |
| CODE(StringChar) | The ASCII code of a character | =CODE("A") | 65 |
| CHAR(ASCII_number) | The character relating to an ASCII code | =CHAR(98) | b |
| RAND() | A random number between 0 and 1 | =RAND() | 0.1521 |
An embedded excel worksheet - you can type values into cells but can not save your changes.
Create a file in Excel and save it to a location on your local disk.
Open OneDrive and select the Public folder.
On the top OneDrive toolbar, select the option to Upload a file.
Right click on a file in your Public folder and choose to Embed
A page opens with a default snippet of HTML code for an iFrame. This can be copied to an appropriate location within a web page.
Alternatively, follow the link to 'Customise how this embedded workbook will look to others'. Various options allow you to change the appearance of the worksheet and whether to allow users to edit cells. An amended code can then be copied.
Dates can appear in the wrong format within the web app and will adopt the US mm/dd/yyyy pattern. If you enter a date in your local pattern (e.g. dd/mm/yy) this may not be recognised and gets converted to text. Excel on your PC will adopt your local regional settings and opening the uploaded sheet within the OneDrive Excel OnLine service should apply your OneDrive location settings. The embedded extract however ignores both configurations.
It appears that this problem can be avoided by applying a custom date format to the relevant cells. Set this in Excel, even if your custom format replicates the default setting. Once the file is uploaded to your public OneDrive folder this setting gets retained in the embedded web app.
| This page is not included in the Excel Functions guide |
 |
Click here for details about obtaining this file |
| file: XL_CharCodeOneDrive.htm | © meadinkent.co.uk 2015 | Page updated Jan15 | CMIDX S7 P10 N |