<div dir="ltr"><p class="gmail-yiv4047995604MsoNormal" style="color:rgb(38,40,42);font-family:"Helvetica Neue",Helvetica,Arial,sans-serif;font-size:13px">Prezados(as)</p><p class="gmail-yiv4047995604MsoNormal" style="color:rgb(38,40,42);font-family:"Helvetica Neue",Helvetica,Arial,sans-serif;font-size:13px"> </p><p class="gmail-yiv4047995604MsoNormal" style="color:rgb(38,40,42);font-family:"Helvetica Neue",Helvetica,Arial,sans-serif;font-size:13px">Estou tentando transferir para uma planilha excel o resultado de uma tabulação que me gera o objeto “table†abaixo.</p><p class="gmail-yiv4047995604MsoNormal" style="color:rgb(38,40,42);font-family:"Helvetica Neue",Helvetica,Arial,sans-serif;font-size:13px">>t03</p><p class="gmail-yiv4047995604MsoNormal" style="color:rgb(38,40,42);font-family:"Helvetica Neue",Helvetica,Arial,sans-serif;font-size:13px"> </p><div style="color:rgb(38,40,42);font-family:"Helvetica Neue",Helvetica,Arial,sans-serif;font-size:13px"><pre style="white-space:pre-wrap;margin:0cm 0cm 0.0001pt;font-size:10pt;font-family:"Courier New";background:rgb(0,34,64)"><span class="gmail-yiv4047995604golwfgsbbub"><span style="font-family:"Lucida Console";color:white;border:1pt none windowtext;padding:0cm">          Filial1     Filial2  Filial3 Filial4  Filial5</span></span></pre><pre style="white-space:pre-wrap;margin:0cm 0cm 0.0001pt;font-size:10pt;font-family:"Courier New";background:rgb(0,34,64)"><span class="gmail-yiv4047995604golwfgsbbub"><span style="font-family:"Lucida Console";color:white;border:1pt none windowtext;padding:0cm"> Concordo     0.6753247            0.5974026 0.5402299   0.7352941 0.5595238</span></span></pre><pre style="white-space:pre-wrap;margin:0cm 0cm 0.0001pt;font-size:10pt;font-family:"Courier New";background:rgb(0,34,64)"><span class="gmail-yiv4047995604golwfgsbbub"><span style="font-family:"Lucida Console";color:white;border:1pt none windowtext;padding:0cm"> Discordo     0.1168831            0.1688312 0.2241379   0.1029412 0.2321429</span></span></pre><pre style="white-space:pre-wrap;margin:0cm 0cm 0.0001pt;font-size:10pt;font-family:"Courier New";background:rgb(0,34,64)"><span class="gmail-yiv4047995604golwfgsbbub"><span style="font-family:"Lucida Console";color:white;border:1pt none windowtext;padding:0cm"> Não Sei      0.2077922            0.2337662 0.2356322   0.1617647 0.2083333</span></span></pre><pre style="white-space:pre-wrap;margin:0cm 0cm 0.0001pt;font-size:10pt;font-family:"Courier New";background:rgb(0,34,64)"><span class="gmail-yiv4047995604golwfgsbbub"><span style="font-family:"Lucida Console";color:white;border:1pt none windowtext;padding:0cm">         </span></span></pre><pre style="white-space:pre-wrap;margin:0cm 0cm 0.0001pt;font-size:10pt;font-family:"Courier New";background:rgb(0,34,64)"><span class="gmail-yiv4047995604golwfgsbbub"><span style="font-family:"Lucida Console";color:white;border:1pt none windowtext;padding:0cm">              Filial6 Filial7 Filial8 Filial9</span></span></pre><pre style="white-space:pre-wrap;margin:0cm 0cm 0.0001pt;font-size:10pt;font-family:"Courier New";background:rgb(0,34,64)"><span class="gmail-yiv4047995604golwfgsbbub"><span style="font-family:"Lucida Console";color:white;border:1pt none windowtext;padding:0cm"> Concordo 0.7407407 0.8292683  0.5897436 0.6293103</span></span></pre><pre style="white-space:pre-wrap;margin:0cm 0cm 0.0001pt;font-size:10pt;font-family:"Courier New";background:rgb(0,34,64)"><span class="gmail-yiv4047995604golwfgsbbub"><span style="font-family:"Lucida Console";color:white;border:1pt none windowtext;padding:0cm"> Discordo 0.1018519 0.0000000  0.2307692 0.1896552</span></span></pre><pre style="white-space:pre-wrap;margin:0cm 0cm 0.0001pt;font-size:10pt;font-family:"Courier New";background:rgb(0,34,64)"><span class="gmail-yiv4047995604golwfgsbbub"><span style="font-family:"Lucida Console";color:white;border:1pt none windowtext;padding:0cm"> Não Sei 0.1574074 0.1707317  0.1794872 0.1810345</span></span></pre></div><p class="gmail-yiv4047995604MsoNormal" style="color:rgb(38,40,42);font-family:"Helvetica Neue",Helvetica,Arial,sans-serif;font-size:13px"> </p><p class="gmail-yiv4047995604MsoNormal" style="color:rgb(38,40,42);font-family:"Helvetica Neue",Helvetica,Arial,sans-serif;font-size:13px">Estou empregando o pacote openxlsx e uso os seguintes comandos.</p><p class="gmail-yiv4047995604MsoNormal" style="color:rgb(38,40,42);font-family:"Helvetica Neue",Helvetica,Arial,sans-serif;font-size:13px">wb <- loadWorkbook(file = "tab_03_38.xlsx")</p><p class="gmail-yiv4047995604MsoNormal" style="color:rgb(38,40,42);font-family:"Helvetica Neue",Helvetica,Arial,sans-serif;font-size:13px">writeData(wb, sheet = "Planilha1", t03, startCol = 1, startRow = 1, colNames = TRUE, rowNames = TRUE)</p><p class="gmail-yiv4047995604MsoNormal" style="color:rgb(38,40,42);font-family:"Helvetica Neue",Helvetica,Arial,sans-serif;font-size:13px">saveWorkbook(wb, "tab_03_38.xlsx", overwrite = TRUE)</p><p class="gmail-yiv4047995604MsoNormal" style="color:rgb(38,40,42);font-family:"Helvetica Neue",Helvetica,Arial,sans-serif;font-size:13px"> </p><p class="gmail-yiv4047995604MsoNormal" style="color:rgb(38,40,42);font-family:"Helvetica Neue",Helvetica,Arial,sans-serif;font-size:13px">Que está me retornando o seguinte erro:</p><div style="color:rgb(38,40,42);font-family:"Helvetica Neue",Helvetica,Arial,sans-serif;font-size:13px"><pre style="white-space:pre-wrap;margin:0cm 0cm 0.0001pt;font-size:10pt;font-family:"Courier New";background:rgb(0,34,64)"><span class="gmail-yiv4047995604golwfgsbltb"><span style="font-family:"Lucida Console";color:rgb(255,98,140)">Error in write_file(head = sprintf("<sst xmlns=\"<a href="http://schemas.openxmlformats.org/spreadsheetml/2006/main\">http://schemas.openxmlformats.org/spreadsheetml/2006/main\</a>" count=\"%s\" uniqueCount=\"%s\">", : </span></span></pre><pre style="white-space:pre-wrap;margin:0cm 0cm 0.0001pt;font-size:10pt;font-family:"Courier New";background:rgb(0,34,64)"><span class="gmail-yiv4047995604golwfgsbltb"><span style="font-family:"Lucida Console";color:rgb(255,98,140)">  Expecting a single string value: [type=character; extent=0].</span></span><span style="color:white"></span></pre></div><p class="gmail-yiv4047995604MsoNormal" style="color:rgb(38,40,42);font-family:"Helvetica Neue",Helvetica,Arial,sans-serif;font-size:13px"> </p><p class="gmail-yiv4047995604MsoNormal" style="color:rgb(38,40,42);font-family:"Helvetica Neue",Helvetica,Arial,sans-serif;font-size:13px">Fiz inúmeras tentativas e procurei por várias soluções nas diversas redes de conhecimento inclusive no GitHub do criador e não obtive o resultado esperado.</p><p class="gmail-yiv4047995604MsoNormal" style="color:rgb(38,40,42);font-family:"Helvetica Neue",Helvetica,Arial,sans-serif;font-size:13px">Tenho usado há pelo menos 2 anos este pacote para diversos outros trabalhos e estou preocupado com a possibilidade de ter que refazer todos os scripts que se repetem ao longo do ano.</p><p class="gmail-yiv4047995604MsoNormal" style="color:rgb(38,40,42);font-family:"Helvetica Neue",Helvetica,Arial,sans-serif;font-size:13px">Por acaso alguém conhece como solucionar este problema ou poderia me oferecer alguma outra orientação sobre como poderei realizar esta transferência?</p><p class="gmail-yiv4047995604MsoNormal" style="color:rgb(38,40,42);font-family:"Helvetica Neue",Helvetica,Arial,sans-serif;font-size:13px">Agradeço desde já seu apoio.</p><p class="gmail-yiv4047995604MsoNormal" style="color:rgb(38,40,42);font-family:"Helvetica Neue",Helvetica,Arial,sans-serif;font-size:13px">Att.</p><p class="gmail-yiv4047995604MsoNormal" style="color:rgb(38,40,42);font-family:"Helvetica Neue",Helvetica,Arial,sans-serif;font-size:13px">Jobenil Júnior</p><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><br></div></div></div></div>