1. Home
2. php - How to read Google Sheets text preserving font formatting

596 votes

0 answers

php - How to read Google Sheets text preserving font formatting

Get the solution ↓↓↓

I'm considering using spreadsheets as a backed for simple website and tweaking reading google sheets data into html. When reading it, api prints only raw text. Is there a way to read cell text with formatting (bold, italic, spaces, newlines etc.)?

$range = 'Sheet1!A1:A5';
$response = $service->spreadsheets_values->get($spreadsheetId, $range);
$values = $response->getValues();
if (empty($values)) {
   print 'No data found.\n';
} else {
   foreach ($values as $row) {
      for ($i = 0; $i < sizeof($row); $i++) {
          echo $row[$i];
          echo "<br/>";
      }
   }
}
Copy code

screenshot

Undefined asked

2021-12-5

Write your answer

---

Share solution ↓

Additional Information:

Date the issue was resolved:

2021-12-5

Link To Source
Link To Answer People are also looking for solutions of the problem: the browser (or proxy) sent a request that this server could not understand.

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.

Ask a Question

---

Similar questions

Find the answer in similar questions on our website.

223 php - Default text must disappear in textarea upon click using jQuery

563 php - Solve PHP4 to PHP5 ugrade error

214 How to use php str_word_count to count words in a textarea

874 php - Woocommerce product custom field: Check if the input already exist

736 php - Session variables getting unset after installing SSL through AWS Cloudfront

517 php - Rebuild array with standard keys

372 php - Insert file into mysql database as varbinary datatype

449 JSON date to PHP Date

399 arrays - Php if elseif loop is not working fine

364 php - Yii2 dropdown optgroup label

Write quick answer

Do you know the answer to this question? Write a quick response to it. With your help, we will make our community stronger.

About the technologies asked in this question

PHP

PHP (from the English Hypertext Preprocessor - hypertext preprocessor) is a scripting programming language for developing web applications. Supported by most hosting providers, it is one of the most popular tools for creating dynamic websites. The PHP scripting language has gained wide popularity due to its processing speed, simplicity, cross-platform, functionality and distribution of source codes under its own license.
https://www.php.net/

HTML

HTML (English "hyper text markup language" - hypertext markup language) is a special markup language that is used to create sites on the Internet. Browsers understand html perfectly and can interpret it in an understandable way. In general, any page on the site is html-code, which the browser translates into a user-friendly form. By the way, the code of any page is available to everyone.
https://www.w3.org/html/