<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>