Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add Hyperlink #13

Closed
naeimrezaeian opened this issue Oct 4, 2020 · 4 comments
Closed

Add Hyperlink #13

naeimrezaeian opened this issue Oct 4, 2020 · 4 comments

Comments

@naeimrezaeian
Copy link

hi

how i can add Hyperlink in excel tables . i usedthis code but dose not work

`include('SimpleXLSXGen.php');
$books = [
['ISBN', 'title', 'author', 'publisher', 'ctry' ,'link'],
[618260307, 'The Hobbit', 'J. R. R. Tolkien', 'Houghton Mifflin', 'USA','=HYPERLINK("https://google.com","Site")'],
[908606664, 'Slinky Malinki', 'Lynley Dodd', 'Mallinson Rendel', 'NZ','=HYPERLINK("https://google.com","site")']
];

$xlsx = SimpleXLSXGen::fromArray( $books );

$xlsx->downloadAs('table.xlsx');`

@shuchkin
Copy link
Owner

помню, помню
думаю как малой кровью обойтись

@Paulsky
Copy link

Paulsky commented Apr 26, 2021

@naeimrezaeian did you find a solution for this?

@psycho3069
Copy link

помню, помню
думаю как малой кровью обойтись

English please -_-

@shuchkin
Copy link
Owner

shuchkin commented May 2, 2021

try 1.0.10

$data = [
  [ 'hyperlink 1', 'https://ya.ru' ],
  [ 'hyperlink 2', '<a href="https://smspilot.ru/">SMSPILOT WEB2SMS</a>' ],
];
SimpleXLSXGen::fromArray( $data )->download();

@shuchkin shuchkin closed this as completed May 3, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants