E PPTÚVBARofficetool · g˜z wƒ„›Eï˜ PPTÚVBARofficetool{0 RƒOffice˙ Ü oØ 1Ô3¥IR−ó‹˘ fi§¥I

gÄz�w��EïÄ PPTÚVBA Rofficetool {0

R�Office��Ü

oé

1Ô3¥IR�ó¬Æ

�®§¥I<¬�Æ

2014c05�25F

ChinaR 7th Beijing R and Office 1 / 28

gÄz�w��EïÄ PPTÚVBA Rofficetool {0 Office�w LATEX�w ÄuIP�ó��w �wXÚ

8 ¹

1 gÄz�w��EïÄOffice�wLATEX�wÄuIP�ó��w�wXÚ

2 PPTÚVBA

3 Rofficetool {0



8 ¹


2 PPTÚVBA

3 Rofficetool {0



Word�w´¤�=¤�ü��;�



Excel�´�B�ü�óä



PPT·ÜãÚL��w



Office�w��EïÄEâ

�wü�

Word�w·Üu©i'�õ�©�Excel�w·ÜL�Ú¯òPPT�w·ÜãL·ü��ª�w

�EïÄEâ

Office �w¥�?Ûé�Ñ�±dVBA��ÏL��§�éêâ�Cz?1�#§�±¢y�EïÄ



8 ¹


2 PPTÚVBA

3 Rofficetool {0



LATEX{0

{0

5¿Ö�5�Ú��

.¶©uÑ§Ö�lay-tech��E©ü�óä

ÎÜ<MIO�;�ü�XÚ

SC

e1CTeXµhttp://www.ctex.org/CTeXDownloadWindowse%@SC¶LinuxeSCTexLive¦^Notepad++�©�?6ì?1?6Ú?È


http://www.ctex.org/CTeXDownload


LATEX�w«~



LATEX�w��EïÄ

LATEXü�LATEX�±@�´�«�óLATEX´;.��¤�=¤�ü��ª<�I��ÄSN§�ª�dLATEX)ûÙÄu�ó�A5¦�gÄz�w�~B|

�EïÄEâ

(ÜR ¥S��Sweave Eâ�±¢yÄuLATEX�gÄü�¦^knitr ��±¢y(¹{*�gÄz�w



8 ¹


2 PPTÚVBA

3 Rofficetool {0



�þ?�IP�ó))Markdown



Markdown�{{0

IK

# L«�?IKkA�# L«A?IK

�L

* mÞL«ÃS�L§�1\Tab �L«e�?�8aq1. mÞ��8L«kS�L

�L

* mÞL«ÃS�L§�1\Tab �L«e�?�8aq1. mÞ��8L«kS�L

�è

±Tab Î½ö��o��m©�1L«§S�è

ã/

![Foo](http://myhomepage.com/pic.png)


http://myhomepage.com/pic.png


��Ä��w))html5



Ä��html5 �w

Ä��J

html5 �w��A:Ò´Ä��p�w�w«�6èAì§�±¢yª²�

(Üjs Eâ�±muÑ?¿�J��ÀzÐy

�EïÄ

IP.�ó�~�B8¤gÄz�w�õU

knitr JøgÄ)¤Ä��w�õU



8 ¹


2 PPTÚVBA

3 Rofficetool {0



ÄuJava ÚR �±muE,��wXÚ


gÄz�w��EïÄ PPTÚVBA Rofficetool {0 R2PPT ReporteRs

8 ¹

1 gÄz�w��EïÄ

2 PPTÚVBAR2PPTReporteRs

3 Rofficetool {0



8 ¹



3 Rofficetool {0



R2PPT�{0

{0

ÄuCOM�ªö�PPT�R��±#ï½�\��¡

~^õU

#ï½�mPPT©�µPPT.Init / PPT.OpenV\��¡µPPT.AddBlankSlide / PPT.AddTitleSlide /PPT.AddTextSlide3��¡¥\\ã¡µPPT.AddGraphicstoSlide3��¡¥\\L�µPPT.AddDataFrameA^��©�µPPT.ApplyTemplate



R2PPT�«~

library(R2PPT)

# #ï©�myPres <- PPT.Init(method="RDCOMClient")

# V\µ¡myPres <- PPT.AddTitleSlide(myPres, title = "PPT�w",

subtitle = "ÄuR2PPT")

# ©imyPres <- PPT.AddTextSlide(myPres, title = "��w�)",

text="©i«� \rã/ \rL�")

# L�myPres <- PPT.AddTitleOnlySlide(myPres, title = "L�")myPres <- PPT.AddDataFrame(myPres, df = head(iris),

row.names=FALSE, size=c(55, 150, 600, 300))



R2PPT�«~£Y¤

# ã/jpeg(file = "D:\testRplot1.jpeg")hist(rnorm(100))dev.off()myPres <- PPT.AddTitleOnlySlide(myPres, title = "ã/")myPres <- PPT.AddGraphicstoSlide(myPres,

file = "D:\testRplot1.jpeg",size= c(55, 150, 600, 300))

# '4?§myPres <- PPT.Close(myPres)



8 ¹



3 Rofficetool {0



ReporteRs�{0

{0

http://davidgohel.github.io/ReporteRs/index.htmlÄuJAVA �ªö�PPT�R�ÏL��N^COM�JAVA¥5¢y§õU'�´L�±nÜ?nWord!PPT9html��w

~^õU

#ï½�mPPT©�µpptxV\��¡µaddSlide¼êÚslide.layoutëê3��¡¥V\IKµaddTitle / addSubtitle3��¡¥V\©�µaddParagraph3��¡¥\\ã¡µaddPlot3��¡¥\\L�µaddTable


http://davidgohel.github.io/ReporteRs/index.html


ReporteRs�«~

library(ReporteRs)

# ��©iNoptions("ReporteRs-e" = 28)options("ReporteRs-default-font"="Arial")

# Mï#�©�pptx.file <- "document_example.pptx"doc = pptx( title = "title" )

# V\µ¡doc = addSlide( doc, slide.layout = "Title Slide" )doc = addTitle( doc, "PPT�w" )doc = addSubtitle( doc , "ÄuReporteRs")

# V\©idoc = addSlide( doc, slide.layout = "Title and Content" )doc = addTitle( doc, "Texts demo" )doc = addParagraph( doc, value = "haha")



ReporteRs�«~£Y¤

# V\L�doc = addSlide( doc,

slide.layout = "Title and Content" )doc = addTitle( doc, "Table example" )doc = addTable( doc, data = iris[25:33, ] )

# V\ã/doc = addSlide( doc,

slide.layout = "Title and Content" )doc = addTitle( doc, "Plot example" )doc = addPlot( doc, function( ) hist(rnorm(100) )

# �\©�writeDoc( doc, pptx.file)


gÄz�w��EïÄ PPTÚVBA Rofficetool {0 )ÛPPT Rofficetool

8 ¹


2 PPTÚVBA

3 Rofficetool {0)ÛPPTRofficetool



8 ¹


2 PPTÚVBA




PPTé��g(�

PPTA^£PowerPoint.Application¤ù´��Ä��é�§�LPPT�A^§S

��¡ü«©�£Presentations¤Ï~�¬{¡�/��¡0

z�é�éA��äN�PPT©�

��¡�£Slides¤äN,��¡§Ï~�{¡�/��¡0

z�é�éA��¡

ShapesvkÏ��¶¡§�3PPT¥§z��\��ÑéA��äN�ShapeShapes ´PPT¥�Ä:�ö�é�



¦^RDCOMClient�?1��¡(��)Û

library(RDCOMClient)

# MïPowerPointA^pptapp <- COMCreate("PowerPoint.Application")

# �mPPT©�pptfile <- normalizePath("template.pptx",

winslash = "/", mustWork = TRUE)pptpre <- pptapp[["Presentations"]]$Open(pptfile)

# �wPPT©��&Epptpre[["FullName"]]pptpre[["PageSetup"]][["SlideHeight"]]

# ½ ��¡�¡pptslide <- pptpre[["Slides"]]$Item(1)

# ½ �Shapespptslide[["Shapes"]][["Count"]] # Shapesé��êshape1 <- pptslide[["Shapes"]]$Item(1)shape1$Type() # �wShapesé�a.



Shapesé�{0

©i«�

Placeholderé�§?Ò´/140§S��©�«�TextBox é�§?Ò´/170§�\�©�µAutoShape é�§?Ò´/10§�\�/G!²âi�

ãLa

Charté�§?Ò´/30§Office��ãLPictureé�§?Ò´/130§�\�ã¡Tableé�§?Ò´/190§L�é�Diagramé�§?Ò´/240§�\�|�(��é�Lineé�§?Ò´/90§�\��Mediaé�§?Ò´/160§�\�xN©�

|

Groupé�§?Ò´/60§|é�§�AÏ�é�§�±�¹Ù¦�Ä:é�



Shapesé�{0

Ù¦é�

Callout é�§?Ò´/20Comment é�§?Ò´/40Freeform é�§?Ò´/50EmbeddedOLEObject é�§?Ò´/70FormControl é�§?Ò´/80LinkedOLEObject é�§?Ò´/100LinkedPicture é�§?Ò´/110OLEControlObject é�§?Ò´/120TextEffect é�§?Ò´/150ScriptAnchor é�§?Ò´/180Canvas é�§?Ò´/200



~^é��ö�

ö��ª{0ÄuCOM �VBA �p¦^RDCOMClient �¤k�é�Ñ´¶�COMIDispatch �Ú^é�¦^/[[09/$0¼��{Úá5

©�aé�ÏL/Text0á5éSN?1Ö�Ú?U

L�é�ÏL/Cell0á5ö�z��ü��±g1mu¼êÚR¥�Matrix ?1éA

ã/é�Charté�´Office¥(¹�ãLé�Picture é�´Ü�·�ãChart �(¹53R��¸e¿ÂØ�§ ��¬kêâ �¡�(6§ØïÆ3gÄzPPT�w¥¦^Té�§�Ð´¦^·��Pictureé�5�O



é�á5�?U

½ �äN�á5

|^VBA ¥é��g(�½ �'5�á5�±ÏLOffice�¸eVBE�J«µ5Ïé��B��ª´ÏLpé�|¢a,��á59�{

á5?U

RDCOMClient �/<-0$�Î§�±¦^R¥~^��ª?1D�

I�5¿�´§?Uá5�I�òTá5þ��é�D��Cþ§,�ÏLCþD��ª?Uá5§5¿Ø��l,�þ�é�½ �Tá5��2��D�§ÄK¬��

(½I�?U�é�§?�¼êòäNê��\�½ �



8 ¹


2 PPTÚVBA




�80�

�è

GitHubµhttps://github.com/lijian13/Rofficetool

�8õU

OfficegÄz�w�óä�ÏL3PPT��Ä:þ?1?U��ª)¤E,�wéE,�PPTé�?1)Û

�8G�

ÐÚ��uÙ3GitHubþ§8c�±)ÛPPT�é�§¿UòExcel¥�L�êâ�\�PPT¥�L�é�"�5¬O\L�Úã¡�=�!Excelã/�gÄ�#±9VBA��\ë�"


https://github.com/lijian13/Rofficetool


«~�è

library("Rofficetool")pptfile <- "C:/pptfile.pptx"list1 <- parsePPT(pptfile)dF <- irisexcelfile <- "C:/excelfile.xlsx"shtindex <- 1rangelefttop <- c(5, 2)writeDfToRange(dF, excelfile, shtindex, rangelefttop)



Thank you!Homepage: http://www.mango-solutions.com/


http://www.mango-solutions.com/

Documents

E PPTÚVBARofficetool · g˜z wƒ„›Eï˜ PPTÚVBARofficetool{0 RƒOffice˙ Ü oØ 1Ô3¥IR−ó‹˘ fi§¥I