SAP/abap2xlsx
1
0
Fork 0
mirror of https://github.com/abap2xlsx/abap2xlsx.git synced 2025-05-05 20:52:09 +08:00
Code Issues Actions Packages Projects Releases Wiki Activity
882 Commits 9 Branches 7 Tags 35 MiB
sandraros/zexcel_tr_sheet
Commit Graph

882 Commits

This Branch
This Branch
All Branches
Author SHA1 Message Date
Ivan
822f9f75a3 Load file has new importing parameter for sy-batch 
In the interface method ZIF_EXCEL_READER~LOAD_FILE, add an optional
import parameter I_FROM_APPLSERVER of type flag with default SY-BATCH,
and use this parameter, instead of SY-BATCH directly, for the decision
whether to load the file from application or from presentation server.
This will make the method more flexible, decoupling the decision "Where
to read the file from" from the circumstance "Am I in batch mode". By
making the parameter optional and using the default value SY-BATCH, all
existing client code will work as before.
 2014-02-24 15:31:25 -06:00
Ivan
449e312c87 Suggestion by Rüdiger Plantiko 
In methid ZIF_EXCEL_READER~LOAD_FILE, change the import parameter
I_FILENAME from type STRING to the generic type CSEQUENCE, and move it
to a string internally where needed.
This saves the client from having to move a CHAR field to an auxiliary
STRING field, only for not having a "type conflict" when calling the
method.
 2014-02-24 15:24:18 -06:00
Ivan
d844114773 Exception class is no longer marked as final 2014-02-24 15:07:13 -06:00
Ivan
75d100150f Huge file reader by Rüdiger Plantiko 
See more details in this blog
http://scn.sap.com/community/abap/blog/2014/01/27/a-way-of-reading-huge-excel-files
 2014-02-24 12:11:39 -06:00
Ivan
3c85dd399c Update readme file 2014-02-21 11:04:49 -06:00
Gh14Cc10
d60745f47a Corrected Conditional Formatting bug 
Conditional formatting doesn't apply font styles like bold, strikes,
underlines, color and so on.
 2014-02-12 12:18:01 +01:00
Gh14Cc10
1cd76945c6 Revert "Corrected Conditional Formatting bug" 
This reverts commit d01e6ab5ea.
 2014-02-12 12:12:28 +01:00
Gh14Cc10
d01e6ab5ea Corrected Conditional Formatting bug 
Conditional formatting font styles were not applied.
 2014-02-12 12:05:03 +01:00
Gh14Cc10
cc4bb7d226 Revert "Corrected Conditional Formatting bug" 
This reverts commit dda3712f23.
 2014-02-12 12:03:37 +01:00
Gh14Cc10
dda3712f23 Corrected Conditional Formatting bug 
Conditional formatting didn't apply font styles like color, strikes,
bold and so on. Now it is working.
 2014-02-12 11:50:44 +01:00
ivanfemia
b88ba99762 Improved readme file 2014-01-02 15:13:35 -06:00
ivanfemia
33607a7293 Adding test file for ZDEMO_EXCEL29 2014-01-02 11:20:08 -06:00
ivanfemia
732fc1e4e5 Merge pull request #292 from bitdeli-chef/master 
Add a Bitdeli Badge to README
 2013-12-27 11:19:22 -08:00
Bitdeli Chef
99aa7fea4d Add a Bitdeli badge to README 2013-12-27 19:21:30 +00:00
ivanfemia
30990346ce remove APIDoc 2013-12-26 15:20:22 -06:00
ivanfemia
533e4c8de5 Add TOOLS and BUILD directories to the repository 2013-12-26 15:10:43 -06:00
ivanfemia
0d62589e6f Add TOOLS and BUILD directories to the repository 2013-12-26 14:51:34 -06:00
Ivan Femia
6191d1662c Mispelling license.txt 
git-svn-id: https://subversion.assembla.com/svn/abap2xlsx/trunk@440 b7d68dce-7c3c-4a99-8ce0-9ea847f5d049
 2013-12-16 21:29:30 +00:00
Ivan Femia
cc9f7ab043 Licence update to Apache 2.0 
git-svn-id: https://subversion.assembla.com/svn/abap2xlsx/trunk@439 b7d68dce-7c3c-4a99-8ce0-9ea847f5d049
 2013-12-16 21:28:07 +00:00
Ivan Femia
cd5e43193b Databar Conditional Formatting by Albert Lladanosa 
git-svn-id: https://subversion.assembla.com/svn/abap2xlsx/trunk@437 b7d68dce-7c3c-4a99-8ce0-9ea847f5d049
 2013-10-31 21:05:10 +00:00
Ivan Femia
3bae68f551 Set to Test #292 
git-svn-id: https://subversion.assembla.com/svn/abap2xlsx/trunk@434 b7d68dce-7c3c-4a99-8ce0-9ea847f5d049
 2013-09-16 23:20:17 +00:00
Ivan Femia
427ca5c4d8 Fixed #291 
git-svn-id: https://subversion.assembla.com/svn/abap2xlsx/trunk@433 b7d68dce-7c3c-4a99-8ce0-9ea847f5d049
 2013-09-16 23:17:04 +00:00
Ivan Femia
5c6995fe90 Test #290 
It is possible to specify a formula in the field catalog instead of a value (BIND_TABLE)

git-svn-id: https://subversion.assembla.com/svn/abap2xlsx/trunk@432 b7d68dce-7c3c-4a99-8ce0-9ea847f5d049
 2013-09-11 22:07:48 +00:00
Ivan Femia
805472ee61 Ready to test #289 new parameter in the table setting 
git-svn-id: https://subversion.assembla.com/svn/abap2xlsx/trunk@431 b7d68dce-7c3c-4a99-8ce0-9ea847f5d049
 2013-09-11 21:07:09 +00:00
Rene Turnheim
efc9e39f11 Fixed #287 issue. Correct some old problems with langu="1" and add new functions as options for converter: 
Hide column
No header
No subtotal
No filter
This can later be added to bind_alv method.

git-svn-id: https://subversion.assembla.com/svn/abap2xlsx/trunk@429 b7d68dce-7c3c-4a99-8ce0-9ea847f5d049
 2013-08-11 18:48:00 +00:00
Stefan Schmöcker
efedac0571 #284: Added support of reading XLSX-Files where the formulae are not stated explicitly but by reference to another cell holding a reference formula. Thanks to David for supplying the method to shift a formula to another cell. 
Enhanced Demoreport 6 to demonstrate how this new method can be used in other circumstances then reading in an EXCEL-sheet


set to test #268:  Changed unit-test to make use of the extended functionality in ZCX_EXCEL

git-svn-id: https://subversion.assembla.com/svn/abap2xlsx/trunk@428 b7d68dce-7c3c-4a99-8ce0-9ea847f5d049
 2013-08-11 10:43:02 +00:00
Stefan Schmöcker
44fa9a6558 Preparations to advance #268 
Adding messageclass to enable multilingual exceptions and messages and better cross-referencing.
Enhancing ZCX_EXCEL to have a substitute for non-classbased "message .... raising"
and to enable unittests that are independant of logonlanguage when checking exceptions raised this way.

git-svn-id: https://subversion.assembla.com/svn/abap2xlsx/trunk@427 b7d68dce-7c3c-4a99-8ce0-9ea847f5d049
 2013-08-10 21:32:38 +00:00
Gregor Wolf
5035be62e6 Ready to test #271 used standard image from transaction SMW0 
git-svn-id: https://subversion.assembla.com/svn/abap2xlsx/trunk@426 b7d68dce-7c3c-4a99-8ce0-9ea847f5d049
 2013-07-15 18:08:24 +00:00
Gregor Wolf
7d41f42521 Ready to test #271 used standard image from transaction SMW0 
git-svn-id: https://subversion.assembla.com/svn/abap2xlsx/trunk@425 b7d68dce-7c3c-4a99-8ce0-9ea847f5d049
 2013-07-15 17:58:40 +00:00
Alessandro Iannacci
7cb0888b86 Excel of demo 39 has validation issue ready to test #276 
git-svn-id: https://subversion.assembla.com/svn/abap2xlsx/trunk@423 b7d68dce-7c3c-4a99-8ce0-9ea847f5d049
 2013-06-19 16:12:22 +00:00
Gregor Wolf
9448918fa0 Add unit test to ZCL_EXCEL_COMMON=>DESCRIBE_STRUCTURE and fix empty fieldname for DDIC element 
Ready to test #270 ZCL_EXCEL_COMMON=>DESCRIBE_STRUCTURE not covered in unit test

git-svn-id: https://subversion.assembla.com/svn/abap2xlsx/trunk@422 b7d68dce-7c3c-4a99-8ce0-9ea847f5d049
 2013-05-24 10:45:23 +00:00
Gregor Wolf
d84f04f8ac Add unit test for issue #241 Error in ZCL_EXCEL_COMMON=>CONVERT_RANGE2COLUMN_A_ROW 
git-svn-id: https://subversion.assembla.com/svn/abap2xlsx/trunk@421 b7d68dce-7c3c-4a99-8ce0-9ea847f5d049
 2013-05-24 09:20:06 +00:00
Gregor Wolf
41a2b67b0a Fixed failing unit test of ZCL_EXCEL_COMMON 
Ready to test #268

git-svn-id: https://subversion.assembla.com/svn/abap2xlsx/trunk@420 b7d68dce-7c3c-4a99-8ce0-9ea847f5d049
 2013-05-20 20:21:16 +00:00
Gregor Wolf
43ebf7dee1 Update Slinkees of Domains to current SAPlink format 
ready to test #267

git-svn-id: https://subversion.assembla.com/svn/abap2xlsx/trunk@419 b7d68dce-7c3c-4a99-8ce0-9ea847f5d049
 2013-05-11 22:53:58 +00:00
Ivan Femia
e6ce67fc32 Fix an error with not characters values in set_cell method (issue #162) 
git-svn-id: https://subversion.assembla.com/svn/abap2xlsx/trunk@417 b7d68dce-7c3c-4a99-8ce0-9ea847f5d049
 2013-04-09 08:01:05 +00:00
Ivan Femia
9528905a07 ready to test #162 Adding Stefan suggestion and adapting DEMO14 
git-svn-id: https://subversion.assembla.com/svn/abap2xlsx/trunk@415 b7d68dce-7c3c-4a99-8ce0-9ea847f5d049
 2013-04-07 11:38:55 +00:00
Ivan Femia
9a3096cb9b ready to test #257 
git-svn-id: https://subversion.assembla.com/svn/abap2xlsx/trunk@414 b7d68dce-7c3c-4a99-8ce0-9ea847f5d049
 2013-04-07 10:08:22 +00:00
Ivan Femia
7d5635ec6d Ready to test #259 Fix in classes ZCL_EXCEL_AUTOFILTERS, ZCL_EXCEL_AUTOFILTER, ZCL_EXCEL_WORKSHEET, ZCL_EXCEL_WRITER_2007 and ZCL_EXCEL_CONVERTER 
git-svn-id: https://subversion.assembla.com/svn/abap2xlsx/trunk@413 b7d68dce-7c3c-4a99-8ce0-9ea847f5d049
 2013-04-07 10:06:59 +00:00
Gregor Wolf
a3749ac918 Ready to test #259 replaced function module call GET_DYNP_VALUE in the F4_PATH method of ZDEMO_EXCEL_OUTPUTOPT_INCL by DYNP_VALUES_READ 
git-svn-id: https://subversion.assembla.com/svn/abap2xlsx/trunk@412 b7d68dce-7c3c-4a99-8ce0-9ea847f5d049
 2013-04-06 18:02:05 +00:00
Gregor Wolf
b483d68e18 Ready to test #258 - Changed domain of data elements ZEXCEL_RANGE_GUID and ZEXCEL_CELL_STYLE to UUID 
git-svn-id: https://subversion.assembla.com/svn/abap2xlsx/trunk@411 b7d68dce-7c3c-4a99-8ce0-9ea847f5d049
 2013-04-04 19:24:03 +00:00
Alessandro Iannacci
047183e848 Solution to issue #256 
git-svn-id: https://subversion.assembla.com/svn/abap2xlsx/trunk@409 b7d68dce-7c3c-4a99-8ce0-9ea847f5d049
 2013-03-21 17:53:12 +00:00
Gregor Wolf
c1f6d37498 Issue #194: Replace REGEX to split Column & Row with method from the common class in LOAD_WORKSHEET Method of ZCL_EXCEL_READER_2007. 
git-svn-id: https://subversion.assembla.com/svn/abap2xlsx/trunk@407 b7d68dce-7c3c-4a99-8ce0-9ea847f5d049
 2013-02-25 12:25:39 +00:00
Stefan Schmöcker
d4c658e856 set to test #246 
git-svn-id: https://subversion.assembla.com/svn/abap2xlsx/trunk@406 b7d68dce-7c3c-4a99-8ce0-9ea847f5d049
 2013-01-29 21:59:27 +00:00
Gregor Wolf
f4f6d84900 German translation for calendar example 
git-svn-id: https://subversion.assembla.com/svn/abap2xlsx/trunk@404 b7d68dce-7c3c-4a99-8ce0-9ea847f5d049
 2013-01-03 10:34:18 +00:00
Gregor Wolf
2de54c6cbb Support also landscape output for the calendar demo 
git-svn-id: https://subversion.assembla.com/svn/abap2xlsx/trunk@403 b7d68dce-7c3c-4a99-8ce0-9ea847f5d049
 2013-01-03 10:22:31 +00:00
Stefan Schmöcker
5c0c447d6d Set to test #246 - minor error in ZCL_EXCEL_COMMON->CONVERT_COLUMN2INT 
Also normalized code for issue 230 and added 2 exceptioncalls for errors not handled so far

git-svn-id: https://subversion.assembla.com/svn/abap2xlsx/trunk@402 b7d68dce-7c3c-4a99-8ce0-9ea847f5d049
 2012-12-29 12:42:09 +00:00
Gregor Wolf
906f802987 Updated ZDEMO_EXCEL33 to get a short file that allows easy debugging #230 
git-svn-id: https://subversion.assembla.com/svn/abap2xlsx/trunk@401 b7d68dce-7c3c-4a99-8ce0-9ea847f5d049
 2012-12-21 21:11:41 +00:00
Stefan Schmöcker
9b4aaf829f #235 Extended Readerclass to support templating of repeatable rows/columns, minor fix in zcl_excel_common-method for range-area-breakup 
git-svn-id: https://subversion.assembla.com/svn/abap2xlsx/trunk@400 b7d68dce-7c3c-4a99-8ce0-9ea847f5d049
 2012-12-09 11:06:01 +00:00
Stefan Schmöcker
70e0659f82 ZCL_EXCEL_WORKSHEET=>SET_TITLE 
#243 : ' not allowed as first character in title of worksheet
#230 : pimp my code

also readded implementing code of interface printsettings since it seems to have been eradicated when removing the aliases

git-svn-id: https://subversion.assembla.com/svn/abap2xlsx/trunk@399 b7d68dce-7c3c-4a99-8ce0-9ea847f5d049
 2012-12-08 13:11:29 +00:00
Stefan Schmöcker
29f91d9660 finished issues: #241, #242 ( errors in range-formatting / escaping and unescaping of names ) 
worked at issues: #151, #230   ( less restrictive parameters, pimp my code )

git-svn-id: https://subversion.assembla.com/svn/abap2xlsx/trunk@398 b7d68dce-7c3c-4a99-8ce0-9ea847f5d049
 2012-12-08 11:50:10 +00:00