Comments (7)
examples:
use Vtiful\Kernel\Excel;
use Vtiful\Kernel\Format;
$excel = new \Vtiful\Kernel\Excel([
'path' => './'
]);
$excelObject = $excel->fileName('tutorial.xlsx');
$excelHandle = $excelObject->getHandle();
// new format object
$format = new Format($excelHandle);
// set format
$formatResource = $format->bold()
->italic()
->color(Format::COLOR_ORANGE)
->number('#,##0')
->toResource();
// insert data
$filePath = $excelObject->header(['name', 'balance'])
->data([
['viest', 1000],
['wjx', 100000]
])
->setColumn('B:B', 50, $formatResource) // set format
->output();
I hope this example will help you.
from php-ext-xlswriter.
Thank you. This will help me a lot.
But can I ask you for the newest php_xlswriter.dll file?
I'm tried to follow your compile instruction from https://github.com/viest/php-ext-excel-export/blob/master/README_zh.md but it's can't compile. It's told me
"xlswriter not enabled, xlsxwriter.lib or headers not found"
Thank you.
from php-ext-xlswriter.
Your platform is Windows or Linux?
from php-ext-xlswriter.
I'm using Windows PHP 7.1.
from php-ext-xlswriter.
Please download 1.2.4
at PECL
.
PECL is building, just a moment, please.
https://pecl.php.net/package/xlswriter
from php-ext-xlswriter.
Really thank for your time.
Can I ask you how to compile this on windows? So I can build myself, I don't want to waste your time for this.
Thank you.
from php-ext-xlswriter.
https://github.com/viest/php-ext-excel-export/wiki/0%E3%80%81Install#windows
from php-ext-xlswriter.
Related Issues (20)
- xlsx转csv 身份证、手机号 变成科学记数法 HOT 1
- Validation string too long, caused buffer overflow detected
- 设置单元格格式 HOT 1
- 没有找到单元格设置内容颜色功能? HOT 1
- Undocumented cell cache and non-deterministic functions
- 写入图片不支持webp
- constMemory 在1.3.2升级到1.5.5后生成的excel无法打开 HOT 3
- 是不是不能修改现有的excel文件 HOT 1
- 使用内存模式导出,导出过程中CPU很高 HOT 2
- setColumn doesn't change column width if called with explicit null format
- 导出的文件wps能打开,excel打不开 HOT 3
- 当文件名中包含英文冒号时临时文件无法创建 HOT 5
- wps能打开,excel打不开
- 有没有只读的打开方式?
- 【bug】问题比较严重,导出时候丢失部分列 HOT 2
- insertFormula issue
- 读取文件2m以上出现 找不到文件错误
- Does it support excel file to html convertion
- Windows DLL available to download
- 如何在程序中获取PHP-Xlswriter的异常码
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from php-ext-xlswriter.