Request/ImportDataIntoSpreadsheetRequest.pm untested

filter: Statementstmt 0.0% 0 / 100 Branchbran 0.0% 0 / 26 Conditioncond n/a MC/DCmcdc n/a Subroutinesub 0.0% 0 / 14 Podpod 0.0% 0 / 2 totaltotal 0.0% 0 / 142 CC 14 SCAR 47.0
CC
14
Cov
0%
run_http_request
210.0
new
2.0
BEGIN
2.0
CRAP 109.9
1 =begin comment
2
3 Copyright (c) 2026 Aspose.Cells Cloud
4 Permission is hereby granted, free of charge, to any person obtaining a copy
5 of this software and associated documentation files (the "Software"), to deal
6 in the Software without restriction, including without limitation the rights
7 to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
8 copies of the Software, and to permit persons to whom the Software is
9 furnished to do so, subject to the following conditions:
10
11 The above copyright notice and this permission notice shall be included in all
12 copies or substantial portions of the Software.
13
14 THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
15 IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
16 FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
17 AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
18 LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
19 OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
20 SOFTWARE.
21
22 =end comment
23
24 =cut
25
26 package AsposeCellsCloud::Request::ImportDataIntoSpreadsheetRequest;
27
28 require 5.6.0;
29 use strict;
30 use warnings;
31 use utf8;
32 use JSON ;
33 use Data::Dumper;
34 use Module::Runtime qw(use_module);
35 use Log::Any qw($log);
36 use Date::Parse;
37 use DateTime;
38 use File::Basename;
39
40 use base ("Class::Accessor", "Class::Data::Inheritable");
41
42 __PACKAGE__->mk_classdata('attribute_map' => {});
43 __PACKAGE__->mk_classdata('method_documentation' => {});
44 __PACKAGE__->mk_classdata('class_documentation' => {});
45
46
47 # new object
48 sub new {
49 my ($class, %args) = @_;
50
51 my $self = bless {}, $class;
52
53 foreach my $attribute (keys %{$class->attribute_map}) {
54 my $args_key = $class->attribute_map->{$attribute};
55 $self->$attribute( $args{ $args_key } );
56 }
57
58 return $self;
59 }
60
61
62 # Run Operation Request
63 # ImportDataIntoSpreadsheetRequest.datafile : Upload data file. ,
64 # ImportDataIntoSpreadsheetRequest.Spreadsheet : Upload spreadsheet file. ,
65 # ImportDataIntoSpreadsheetRequest.worksheet : Specify the worksheet for importing data ,
66 # ImportDataIntoSpreadsheetRequest.startcell : Specify the starting position for importing data ,
67 # ImportDataIntoSpreadsheetRequest.insert : The specified import data is for insertion and overwrite. ,
68 # ImportDataIntoSpreadsheetRequest.convertNumericData : Specify whether to convert numerical data ,
69 # ImportDataIntoSpreadsheetRequest.splitter : Specify the delimiter for the CSV format. ,
70 # ImportDataIntoSpreadsheetRequest.outPath : (Optional) The folder path where the workbook is stored. The default is null. ,
71 # ImportDataIntoSpreadsheetRequest.outStorageName : Output file Storage Name. ,
72 # ImportDataIntoSpreadsheetRequest.fontsLocation : Use Custom fonts. ,
73 # ImportDataIntoSpreadsheetRequest.region : The spreadsheet region setting. ,
74 # ImportDataIntoSpreadsheetRequest.password : The password for opening spreadsheet file.
75
76 {
77 my $params = {
78 'client' =>{
79 data_type => 'ApiClient',
80 description => 'API Client.',
81 required => '0',
82 }
83 };
84 __PACKAGE__->method_documentation->{ 'import_data_into_spreadsheet' } = {
85 summary => 'Import data into a spreadsheet from a supported data file format.',
86 params => $params,
87 returns => 'string',
88 };
89 }
90
91 sub run_http_request {
92 my ($self, %args) = @_;
93
94 my $client = $args{'client'};
95
96 # parse inputs
97 my $_resource_path = 'v4.0/cells/import/data';
98
99 my $_method = 'PUT';
100 my $query_params = {};
101 my $header_params = {};
102 my $form_params = {};
103
104
105 my $_header_accept = $client->select_header_accept('application/json');
106 if ($_header_accept) {
107 $header_params->{'Accept'} = $_header_accept;
108 }
109 $header_params->{'Content-Type'} = $client->select_header_content_type('multipart/form-data');
110
111 if(defined $self->worksheet){
112 $query_params->{'worksheet'} = $client->to_query_value($self->worksheet);
113 }
114
115 if(defined $self->startcell){
116 $query_params->{'startcell'} = $client->to_query_value($self->startcell);
117 }
118
119 if(defined $self->insert){
120 $query_params->{'insert'} = $client->to_query_value($self->insert);
121 }
122
123 if(defined $self->convert_numeric_data){
124 $query_params->{'convertNumericData'} = $client->to_query_value($self->convert_numeric_data);
125 }
126
127 if(defined $self->splitter){
128 $query_params->{'splitter'} = $client->to_query_value($self->splitter);
129 }
130
131 if(defined $self->out_path){
132 $query_params->{'outPath'} = $client->to_query_value($self->out_path);
133 }
134
135 if(defined $self->out_storage_name){
136 $query_params->{'outStorageName'} = $client->to_query_value($self->out_storage_name);
137 }
138
139 if(defined $self->fonts_location){
140 $query_params->{'fontsLocation'} = $client->to_query_value($self->fonts_location);
141 }
142
143 if(defined $self->region){
144 $query_params->{'region'} = $client->to_query_value($self->region);
145 }
146
147 if(defined $self->password){
148 $query_params->{'password'} = $client->to_query_value($self->password);
149 }
150 my $_body_data;
151
152
153 if (defined $self->datafile) {
154 $form_params->{basename($self->datafile)} = [$self->datafile ,basename($self->datafile),'application/octet-stream'];
155 }
156
157
158 if (defined $self->spreadsheet) {
159 $form_params->{basename($self->spreadsheet)} = [$self->spreadsheet ,basename($self->spreadsheet),'application/octet-stream'];
160 }
161
162
163 # authentication setting, if any
164 my $auth_settings = [qw()];
165
166 # make the API Call
167 my $response = $client->call_api($_resource_path, $_method, $query_params, $form_params, $header_params, $_body_data, $auth_settings);
168 return $response;
169 }
170
171
172 __PACKAGE__->method_documentation({
173 'datafile' => {
174 datatype => 'string',
175 base_name => 'datafile',
176 description => 'Upload data file.',
177 format => '',
178 read_only => '',
179 },
180 'spreadsheet' => {
181 datatype => 'string',
182 base_name => 'Spreadsheet',
183 description => 'Upload spreadsheet file.',
184 format => '',
185 read_only => '',
186 },
187 'worksheet' => {
188 datatype => 'string',
189 base_name => 'worksheet',
190 description => 'Specify the worksheet for importing data',
191 format => '',
192 read_only => '',
193 },
194 'startcell' => {
195 datatype => 'string',
196 base_name => 'startcell',
197 description => 'Specify the starting position for importing data',
198 format => '',
199 read_only => '',
200 },
201 'insert' => {
202 datatype => 'string',
203 base_name => 'insert',
204 description => 'The specified import data is for insertion and overwrite.',
205 format => '',
206 read_only => '',
207 },
208 'convert_numeric_data' => {
209 datatype => 'string',
210 base_name => 'convertNumericData',
211 description => 'Specify whether to convert numerical data',
212 format => '',
213 read_only => '',
214 },
215 'splitter' => {
216 datatype => 'string',
217 base_name => 'splitter',
218 description => 'Specify the delimiter for the CSV format.',
219 format => '',
220 read_only => '',
221 },
222 'out_path' => {
223 datatype => 'string',
224 base_name => 'outPath',
225 description => '(Optional) The folder path where the workbook is stored. The default is null.',
226 format => '',
227 read_only => '',
228 },
229 'out_storage_name' => {
230 datatype => 'string',
231 base_name => 'outStorageName',
232 description => 'Output file Storage Name.',
233 format => '',
234 read_only => '',
235 },
236 'fonts_location' => {
237 datatype => 'string',
238 base_name => 'fontsLocation',
239 description => 'Use Custom fonts.',
240 format => '',
241 read_only => '',
242 },
243 'region' => {
244 datatype => 'string',
245 base_name => 'region',
246 description => 'The spreadsheet region setting.',
247 format => '',
248 read_only => '',
249 },
250 'password' => {
251 datatype => 'string',
252 base_name => 'password',
253 description => 'The password for opening spreadsheet file.',
254 format => '',
255 read_only => '',
256 },
257 });
258
259
260 __PACKAGE__->attribute_map( {
261 'datafile' => 'datafile',
262 'spreadsheet' => 'Spreadsheet',
263 'worksheet' => 'worksheet',
264 'startcell' => 'startcell',
265 'insert' => 'insert',
266 'convert_numeric_data' => 'convertNumericData',
267 'splitter' => 'splitter',
268 'out_path' => 'outPath',
269 'out_storage_name' => 'outStorageName',
270 'fonts_location' => 'fontsLocation',
271 'region' => 'region',
272 'password' => 'password'
273 } );
274
275 __PACKAGE__->mk_accessors(keys %{__PACKAGE__->attribute_map});
276
277
278 1;